Critical System Tables in 2008

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

  • sysallocunits

  • syshobts

  • syshobtcolumns

  • sysrowsets

  • sysrowsetcolumns

more ▼

asked Jul 13, 2010 at 09:27 AM in Default

avatar image

34 3 3 6

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jul 13, 2010 at 11:10 AM

avatar image

Grant Fritchey ♦♦
137k 20 46 81

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.

Jul 13, 2010 at 11:24 AM Matt Whitfield ♦♦

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.

Jul 13, 2010 at 12:13 PM Grant Fritchey ♦♦

That's one thing that sucks about being UK based - we get to miss out on a lot of opportunities!

Jul 13, 2010 at 12:16 PM Matt Whitfield ♦♦

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.

Jul 13, 2010 at 12:19 PM 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

They we're doing in a master class @ heathrow a couple of weeks ago.. Impressive!

Jul 13, 2010 at 12:56 PM sp_lock
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 13, 2010 at 09:27 AM

Seen: 1475 times

Last Updated: Jul 13, 2010 at 11:58 AM

Copyright 2018 Redgate Software. Privacy Policy