Validation statements

Description

are checked.

,

be repaired.

individual repair level.

completed.

phase.

Note:

is

executed.

Progress isn’t reported.

The consistency of database catalogs is checked during

this phase.

is

executed.

Progress isn’t reported.

the database is checked during this phase.

level of the individual

checked.

DBCC INPUTBUFFER

DBCC SHOWCONTIG

DBCC OPENTRAN

DBCC OUTPUTBUFFER

DBCC PROCCACHE

DBCC SHOW_STATISTICS

DBCC SQLPERF

DBCC TRACESTATUS

DBCC USEROPTIONS

DBCC CHECKALLOC

DBCC SYS
REPAIR

REPAIR_FAST

REPAIR_REBUILD

REPAIR_ALLOW_DATA_LOSS

DBCC SSB
CHECK

DBCC CHECKTABLE

DBCC
CHECKCATALOG

DBCC CHECKTABLE

DBCC IVIEW
CHECK