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

DBCC CHECKDB Expand / Collapse
Author
Message
Posted Thursday, September 06, 2012 2:52 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 11, 2014 12:35 AM
Points: 28, Visits: 152
How does DBCC CHECKDB works? What is the expected time to finish if the database size is about 800 GB?
Post #1355126
Posted Thursday, September 06, 2012 5:15 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:20 PM
Points: 41,529, Visits: 34,445
At a very high level it checks the metadata for consistency, checks the allocation structures for consistency and then checks every table in the DB for damaged pages, bad links and several other things.

As for the time, cannot answer that.
http://sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-How-long-will-CHECKDB-take-to-run.aspx



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1355220
Posted Thursday, September 06, 2012 11:57 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 11, 2014 12:35 AM
Points: 28, Visits: 152
It has no database repair on DBCC CHECKDB? How about if the database has been mirrored?
Post #1355762
Posted Friday, September 07, 2012 12:19 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 06, 2014 6:06 PM
Points: 286, Visits: 570
Yes there are repair options but these are not run by default. There are REPAIR_REBUILD and REPAIR_ALLOW_DATA_LOSS options.

marygrace_laurente23 (9/6/2012)
How about if the database has been mirrored?


Not sure what you mean? If you're asking whether you can run DBCC CHECKDB on a mirrored database, then yes, certainly you can (well I do!)


Clare
_________________________________________________________________________________________________________________
Measure twice; cut once (and have a good saw)

Hey, just a thought.....did you check Books Online yet?
Post #1355771
Posted Thursday, November 28, 2013 2:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 8:14 AM
Points: 65, Visits: 300
How do you run a DBCC Check DB against the database that is acting as a Mirror? When I try, I get the standard message saying I can't run it against the database as it's acting as a Mirror database.
Post #1518298
Posted Monday, December 02, 2013 6:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 5:29 AM
Points: 147, Visits: 580
on which database you are running DBCC command, you can only run this on pricipal server not on mirrored server.



Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com
Post #1518869
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse