Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

DBCC CHECKDB - System databases Expand / Collapse
Posted Tuesday, November 23, 2010 4:14 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 7:00 PM
Points: 251, Visits: 760
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.

Post #1025006
Posted Tuesday, November 23, 2010 4:51 AM



Group: General Forum Members
Last Login: Yesterday @ 5:18 AM
Points: 45,619, Visits: 44,147
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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1025031
Posted Tuesday, November 30, 2010 8:40 AM



Group: Administrators
Last Login: Today @ 11:12 AM
Points: 34,363, Visits: 18,576
I agree with Gail. I would run this daily on my system databases.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1028024
Posted Tuesday, November 30, 2010 8:55 AM



Group: General Forum Members
Last Login: Wednesday, October 12, 2016 9:27 AM
Points: 2,053, Visits: 1,712

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, Check out SQLskills online training! 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
Post #1028035
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse