Microsoft® SQL Server® 2008 Internals

DBCC CHECKDB Output

DBCC CHECKDB outputs information in four ways:

• Regular output, consisting of a list of errors and informational messages to the connection issuing the DBCC CHECKDB command

• A message in the SQL Server error log

• An entry in the Microsoft Windows application event log

• Progress reporting information in the sys.dm_exec_requests catalog view

Regular Output

By default, DBCC CHECKDB reports the following:

• A summary of the Service Broker consistency checks

• A list of allocation errors, plus a count of these errors

• A list of errors where the affected table cannot be determined, plus a count of these errors

• For each table in the database (including system catalogs):

  • The number of rows and pages

  • The list of errors, along with a count of these errors ...