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

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.

Example

-- Check the current database.
DBCC CHECKDB;
GO

"There are moments when everything goes well; don't be frightened, it won't last" ~ Jules Renard

Related

Brian Cryer How To - Run DBCC checkdb on each database (using cursors)


© Copyright SS64.com 1999-2014
Some rights reserved