Chapter 10: Checking Database Consistency

What checks can be performed with dbcc?

Table 10-1 summarizes the checks performed by the dbcc commands. Table 10-2 compares the different dbcc commands.

**Table 10-1: Comparison of checks performed by **dbcc** commands**
Checks performed	checkstorage	checktable	checkdb	checkalloc	indexalloc	tablealloc	checkcatalog
Allocation of text valued columns	X
Index consistency		X	X
Index sort order		X	X
OAM page entries	X	X	X		X	X
Page allocation	X			X	X	X
Page consistency	X	X	X
Pointer consistency	X	X	X
System tables							X
Text column chains	X	X	X	X
Text valued columns	X	X	X

You can run all dbcc commands except dbrepair and checkdb with the fix option while the database is active.

Only the table owner can execute dbcc with the checktable, fix_text, or reindex keywords. Only the Database Owner can use the checkstorage, checkdb, checkcatalog, checkalloc, indexalloc, and tablealloc keywords. Only a System Administrator can use the dbrepair keyword.

Checking consistency of databases and tables

View this book as PDF