DBCC CHECKFILEGROUP SQL Server 2005 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 |