CheckDB

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sankar Reddy » CheckDB

30 posts, Page 1 of 3

1 2 3 »»»

CheckDB

Rate Topic

Display Mode

Topic Options

Author

Message

Sankar Reddy

Posted Sunday, August 16, 2009 5:37 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 2:59 PM
Points: 382, Visits: 1,104

Comments posted to this topic are about the item CheckDB

Sankar Reddy | http://SankarReddy.com/

Post #771600

ChiragNS

Posted Monday, August 17, 2009 2:07 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

The options you mentioned are not clear.

It will fail when trying to run against tempdb database.
It will fail when trying to run against the master database

DBCC CheckDB does not "fail" while running against master or tempdb databases.

"Keep Trying"

Post #771748

Dietmar Weickert

Posted Monday, August 17, 2009 4:32 AM

SSCommitted

Group: General Forum Members
Last Login: Friday, January 11, 2013 8:20 AM
Points: 1,608, Visits: 373

It is comprehensive and validates the logical and physical integrity of all the objects in the specified database including tables, indexes, indexed views & statistics.

What's wrong with this statement?

Best regards,
Dietmar Weickert.

Post #771787

spaghettidba

Posted Monday, August 17, 2009 6:30 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:29 AM
Points: 4,804, Visits: 8,067

DBCC CHECKDB runs againt master and tempdb with no errors. I wouldn't say it fails, I would say it doesn't behave exactly as you expect.

Get your two-cent-answer quickly
The Spaghetti DBA

Post #771841

Bill Mell

Posted Monday, August 17, 2009 6:35 AM

SSChasing Mays

Group: General Forum Members
Last Login: Saturday, March 19, 2011 12:37 PM
Points: 603, Visits: 63

DBCC CHECKDB does NOT fail when run against tempdb.

Post #771845

Rob Goddard

Posted Monday, August 17, 2009 7:08 AM

SSChasing Mays

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 3:48 AM
Points: 660, Visits: 557

Dietmar Weickert (8/17/2009)

It is comprehensive and validates the logical and physical integrity of all the objects in the specified database including tables, indexes, indexed views & statistics.

What's wrong with this statement?

Ditto...

I picked this option and it's the only reason I was wrong, be nice to know why that particular option is incorrect (I'm assuming it's the stats, but can't confirm that in BOL anywhere).

For the few mentioning that DBCC CHECKDB does not fail on master or tempdb, you're right, but the way I read the question, it's not stating otherwise is it?

--------
I love deadlines. I like the whooshing sound they make as they fly by. -Douglas Adams

Post #771870

jjtetzlo

Posted Monday, August 17, 2009 7:54 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:33 PM
Points: 1,090, Visits: 4,540

If only 2% of people are getting this correct, it's a sign of a badly written question.

- Jeff

Post #771911

Chad Crawford

Posted Monday, August 17, 2009 8:07 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 4:17 PM
Points: 2,548, Visits: 17,356

I picked this option and it's the only reason I was wrong, be nice to know why that particular option is incorrect (I'm assuming it's the stats, but can't confirm that in BOL anywhere).

Same here - that is the only option I got wrong. I did find these links about stats after answering the QOD: Bug #: 443756, Bug 158623. They are both for 2K5, but probably still valid.

Post #771924

Cliff Jones

Posted Monday, August 17, 2009 9:13 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 12:39 PM
Points: 3,397, Visits: 3,405

So what kind of an error message does the author recieve when running CHECKDB agains the tempdb? I am not seeing it.

Post #771993

bitbucket-25253

Posted Monday, August 17, 2009 9:21 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:16 PM
Points: 5,101, Visits: 20,201

I firmly believe the author of this question did NOT perform due diligence when selecting possible answers.

The original statement

Check all that apply that are true about

In the case of the master and temp db the question statement should have been: Check all that may apply and are true about

From Books On Line
DBCC CHECKDB

Runs DBCC CHECKALLOC on the database.
Runs DBCC CHECKTABLE on every table and view in the database.
Runs DBCC CHECKCATALOG on the database

From DBCC CHECKALLOC.
http://technet.microsoft.com/en-us/library/aa258809(SQL.80).aspx

Note NOINDEX is maintained for backward compatibility only. All indexes are checked when executing DBCC CHECKALLOC.

So in effect using DBCC CHECKDB which in turn invokes DBCC CHECLALLOC the correct answer is: does check all indexes

On the last possible answer also see:
CHECK STATISTICS
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=158623

(Bold facing entered by myself to drive home my arguement)

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #771999

« Prev Topic | Next Topic »

30 posts, Page 1 of 3

1 2 3 »»»

Permissions