Quick Overview of DBCC CHECKDB

Posted by on April 7, 2015 Leave a comment (0) Go to comments

It includes all these 3 DBCC commands run individually

    DBCC CHECKALLOC
    DBCC CHECKTABLE
    DBCC CHECKCATALOG

If DBCC CHECKDB fails the best option is restore from the backup or try with repair allow data loss option by putting in emergency mode and then single user mode. If fixed move back to multi user mode again.

Uncategorized

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>