O'Reilly logo

Microsoft® SQL Server® 2008 Internals by Paul Randal Kalen Delaney Kimberly Tripp, and Conor Cunningham

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required