Can anyone tell me what the critical system tables are in 2008 that are checked within a CHECKDB? I'm trying to break down CHECKDB into parts as described on [msdn] as the full check takes too long
In 2005 they are
Jul 13, 2010 at 09:27 AM
Jul 13, 2010 at 11:58 AM
Kev Riley ♦♦
I honestly don't know, but I would suggest you [go here] to get the answers. Paul wrote the original DBCC process and is still extremely involved with SQL Server development.
Jul 13, 2010 at 11:10 AM
Grant Fritchey ♦♦
To to add to @Grant post... I think this article is the best http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-Complete-description-of-all-CHECKDB-stages.aspx
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Jul 13, 2010 at 09:27 AM
Seen: 1318 times
Last Updated: Jul 13, 2010 at 11:58 AM
Timeout during DBCC CHECKDB
Breaking down DBCC CHECKTABLE by individual index?
SQL Server 2005 Error
DBCC CHECKDB with FAT32 file-system?
DBCC CHECKDB WITH NO_INFOMSGS
Validate a backup file before configuring mirroring
Comparing two records from two rows and do something IF > 3
Operand data type varchar is invalid for subtract operator.
sql server 2008 R2?