Thanks! Awesome advice... and it makes so much sense. Will implement exactly as you suggested.
I'm starting to plan an upgrade to SQL Server 2008. Here is my current configuration: 2 Clustered Servers running Windows Server 2003 and SQL Server...
Hello; Once a month Micrsoft Security updates are installed. The primary node receives the updates first, reboots and completes the Failover to the...
Last night my Primary Node failed over to the Passive Node. Everything seems to be working fine. My question is: Where do I look to determine WHY it...
I'm preparing to install SP3. I noticed in the installation notes that there are two information gathering tools available. The first one is called:...
Thanks!!! Now I can assure management that no other steps are necessary after data is deleted.
When a record is deleted in the database, is it permanently deleted? That is --- can I say that there is NO way that data can be retrieved off a hard...
Thanks for your insight. I think I finally understand how to perform backups. I need to incorporate differential backups into my strategy and get...
Notice that I said I keep the full backups for 2 days only. What do I do if there is data loss from 7 days ago --- I can't go back and retrieve data....
I am currently performing a full backup every evening and keeping the backups for 2 days. Is it possible for me to keep this schedule and at the same...
Thanks!!! That was a big help..
Guess I'll have to try the install again... Node A (my primary Node) is working fine and I can now generate reports that previously wouldn't work. Is...
I followed it exactly... and everything looked fine until I switched to Node B.
Here is the URL for the article.....
SQL Sever 2005 in a clustered environment. Printed out advice from Linchi Shea. Succesfully installed hotfix on Node A. When trying to install hotfix...
Separate names with a comma.
