|
DBCC CHECKFILEGROUP - Check the allocation and structural integrity of all tables and indexed views in a filegroup.
Syntax DBCC CHECKFILEGROUP [( 'filegroup' | filegroup_id | 0 [, NOINDEX ] )] [WITH [ALL_ERRORMSGS NO_INFOMSGS] [, TABLOCK ] [ , ESTIMATEONLY ] ] Key: filegroup_name - The name of the filegroup to be checked. default (or if 0 is specified) = the primary filegroup. NOINDEX - Skip intensive checks of nonclustered indexes. ALL_ERRORMSGS - Return all reported errors per object, default = first 200 errors. TABLOCK - Obtain locks instead of using an internal database snapshot. ESTIMATEONLY - Display the estimated amount of tempdb space that would be required.
Examples
-- Check the primary filegroup in 'MyDatabase' USE MyDatabase;
GO
DBCC CHECKFILEGROUP;
GO
"One of the most important ways to manifest integrity is to be loyal to
those who are not present. In doing so, we build the trust of those who
are present" - Stephen Covey
Related
DBCC CHECKTABLE - Check integrity of a table or indexed view.