1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Dbcc checkdb help

Discussion in 'SQL Server' started by Neverdiez, Jun 24, 2009.

  1. Neverdiez

    Neverdiez New Member

    Hi guys

    Can you people list all the DBCC CHECKDB codes to repair a database.

    I have consistency errors, I have run the DATA_ALLOW_DATA_LOSS, it fixed a couple but I still have some.
  2. sql-programs

    sql-programs New Member

    DBCC CHECKDB - Check the allocation, and integrity of all objects in a database.

          DBCC CHECKDB 
             [( 'database' | database_id | 0
                  [ , NOINDEX 
                 [ALL_ERRORMSGS ] [ , NO_INFOMSGS ] [ , TABLOCK ]
                    [, ESTIMATEONLY ] [ , { PHYSICAL_ONLY | DATA_PURITY } ]
       NOINDEX        - Skip intensive checks of nonclustered indexes for user tables
       REPAIR_ALLOW_DATA_LOSS - Try to repair all reported errors.
       REPAIR_REBUILD - Perform all repairs that can be performed without risk of data loss.
       ALL_ERRORMSGS  - Return all reported errors per object, default = first 200 errors.
       TABLOCK        - Obtain locks instead of using an internal database snapshot. 
                        this limits the checks that are performed.
       ESTIMATEONLY   - Display the estimated amount of tempdb space that would be required.
       PHYSICAL_ONLY  - Limits the checking to the integrity of the physical structure
       DATA_PURITY    - Check the database for column values that are not valid or out-of-range.
    shabbir likes this.

Share This Page