Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

CheckDB Expand / Collapse
Author
Message
Posted Sunday, August 16, 2009 5:37 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, March 24, 2014 5:16 PM
Points: 382, Visits: 1,136
Comments posted to this topic are about the item CheckDB

Sankar Reddy | http://SankarReddy.com/
Post #771600
Posted Monday, August 17, 2009 2:07 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 1:27 AM
Points: 2,366, Visits: 1,837
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
Posted Monday, August 17, 2009 4:32 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

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
Posted Monday, August 17, 2009 6:30 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:43 AM
Points: 4,903, Visits: 8,585
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.

--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #771841
Posted Monday, August 17, 2009 6:35 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing 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
Posted Monday, August 17, 2009 7:08 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, May 24, 2013 5:20 AM
Points: 660, Visits: 558
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
Posted Monday, August 17, 2009 7:54 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 7:28 AM
Points: 1,279, Visits: 4,731
If only 2% of people are getting this correct, it's a sign of a badly written question.

- Jeff
Post #771911
Posted Monday, August 17, 2009 8:07 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 04, 2014 8:25 AM
Points: 2,602, Visits: 17,845
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
Posted Monday, August 17, 2009 9:13 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:04 AM
Points: 3,764, Visits: 3,581
So what kind of an error message does the author recieve when running CHECKDB agains the tempdb? I am not seeing it.
Post #771993
Posted Monday, August 17, 2009 9:21 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:04 AM
Points: 5,468, Visits: 23,455
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 »

Add to briefcase 123»»»

Permissions Expand / Collapse