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.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
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: 1233 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
How to use ORDER BY, LOWER in SQL SERVER 2008 with non-unicode data
migrating from sql server 2005 to sql server 2008
How to consolidate multiple similar SSIS packages that export data to txt file