October 2010
Intermediate to advanced
1008 pages
46h 16m
English
DBCC CHECKDB is the most frequently used validation command for checking the logical and physical integrity of the whole database. Essentially, DBCC CHECKDB is a superset command that actually runs CHECKALLOC, CHECKTABLE, and CHECKCATALOG.
Here are some recommendations for using DBCC CHECKDB:
• Administrators should run DBCC CHECKDB rather than the individual operations because it identifies most of the errors and is generally safe to run in a production environment.
• After running DBCC CHECKDB, administrators should run it again with the REPAIR argument to repair any reported errors.
• DBCC CHECKDB can be time-consuming, and it acquires schema locks that prevent metadata changes; therefore, it is highly ...
Read now
Unlock full access