DBCC CHECKDB Options

The syntax diagram for DBCC CHECKDB from SQL Server Books Online is

DBCC CHECKDB
[
    [ ( database_name | database_id | 0
        [ , NOINDEX
        | , { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD } ]
        ) ]
    [ WITH
        {
            [ ALL_ERRORMSGS ]
            [ , EXTENDED_LOGICAL_CHECKS ]
            [ , NO_INFOMSGS ]
            [ , TABLOCK ]
            [ , ESTIMATEONLY ]
            [ , { PHYSICAL_ONLY | DATA_PURITY } ]
        }
    ]
]

The rest of this section explains these options, with additional information to that in SQL Server Books Online.

NOINDEX

The NOINDEX option makes DBCC CHECKDB skip the nonclustered index cross-checks on user tables (that is, nonclustered index cross-checks are always performed on system tables when this option is specified). These checks are very CPU-intensive so turning them off can ...

Get Microsoft® SQL Server® 2008 Internals 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