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 ♦♦
I like and loathe reading Paul's blog. I like it because I learn so much, and it's so well written, and I loathe it because it usually reminds me how rubbish I am. I would love to meet him one day / take a course with him.
I have met him. Actually I was on stage with him and his wife at the last PASS summit for a game. It was an horrifyingly embarassing beating because they were so very smart and well informed and I'm just not. But, they're great people, very nice. Excellent teachers and presenters too.
That's one thing that sucks about being UK based - we get to miss out on a lot of opportunities!
I've only been to one of Paul's classes, but I've attended a ton of Kim's. She's scary smart. I learn something every time. I thought they traveled over there occasionally... Wait, they were just in Ireland for a couple of weeks at least. I know it's another country, but it's only a few hours away.
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
They we're doing in a master class @ heathrow a couple of weeks ago.. Impressive!
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: 1461 times
Last Updated: Jul 13, 2010 at 11:58 AM
SQL Server 2005 Error
DBCC CHECKDB with FAT32 file-system?
DBCC CHECKDB WITH NO_INFOMSGS
Validate a backup file before configuring mirroring
DBCC CheckDB Failed
Timeout during DBCC CHECKDB
Breaking down DBCC CHECKTABLE by individual index?
How to delete rows in batches using a stored procedure that delete from parent and all child records to avoid filling the transaction log
sqlserver 2008 compliant with which version of ANSI stanard ?