Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   Dbcc checkdb help (http://www.go4expert.com/forums/dbcc-checkdb-help-t18167/)

Neverdiez 24Jun2009 18:13

Dbcc checkdb help
 
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.

sql-programs 20Nov2009 00:19

Re: Dbcc checkdb help
 
DBCC CHECKDB - Check the allocation, and integrity of all objects in a database.

Code:

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

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



All times are GMT +5.5. The time now is 19:03.