March 30, 2010 at 10:08 pm
I have a quick question: Has anybody ever encountered the problem of system databases being corrupted? If you find your system db's corrupted, what do you do ?
March 31, 2010 at 1:45 am
Yes they do, just like user databases do. There's nothing special about the system databases that will save them from having the IO subsystem mangle their files.
With the system databases most repairs don't work, either because the tables are all system (like master and model) or because repair can have lingering effects if it deletes the wrong stuff (MSDB). Hence the generally recommended fix for corrupt system databases is restore from backup.
That's why it's important to have backups of the system databases and to run integrity checks on them, just like on user databases.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply