September 6, 2012 at 2:52 am
How does DBCC CHECKDB works? What is the expected time to finish if the database size is about 800 GB?
September 6, 2012 at 5:15 am
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 6, 2012 at 11:57 pm
It has no database repair on DBCC CHECKDB? How about if the database has been mirrored?
September 7, 2012 at 12:19 am
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!)
November 28, 2013 at 2:45 am
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.
December 2, 2013 at 6:09 am
on which database you are running DBCC command, you can only run this on pricipal server not on mirrored server.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply