Reading the Output from DBCC Commands

DBCC commands often generate a great amount of output. The problem is determining what is relevant within the output. Use the following list as a guide of what to look for in the DBCC output:

  • Any message that contains the string corrupt (for example, Table Corrupt).

  • Error messages that range from 2500 to 2599 or 7900 to 7999. DBCC error messages usually contain these error numbers.

  • Messages that contain the string error.

TIP

To help reduce the amount of information returned by a DBCC command use the WITH NO_INFOMSGS option. By using this option, DBCC will return only relevant information such as error messages. For example

DBCC CHECKDB (pubs) WITH NO_INFOMSGS

The following DBCC commands support the WITH NO_INFOMSGS ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial