November 23, 2010 at 4:14 am
Dear All,
Can we run DBCC CHECKDB on system databases( master,model and msdb)?
Kindly advise whether it is fine or not.
Thanks in advance.
Regards,
Ravichandra.
November 23, 2010 at 4:51 am
It's essential that the system databases (other than tempDB) be regularly checked. Otherwise how will you know if there's corruption? Finding corruption when master goes suspect is a really bad way to start a day.
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
November 30, 2010 at 8:40 am
I agree with Gail. I would run this daily on my system databases.
November 30, 2010 at 8:55 am
Absolutely.
To clarify what Gail said, tempdb should also be checked, but CHECKDB runs very differently on tempdb so it doesn't all get checked. This is because the underlying mechanism CHECKDB uses (database snapshots) aren't possible on tempdb, so CHECKDB has to resort to taking table locks. I would not attemp to check tempdb every day - try weekly.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply