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 ] [ , PHYSICAL_ONLY ]
         ]
 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.
   PHYSICAL_ONLY  - Limit checking to the integrity of the physical structure of the page,
                    record headers and the physical structure of B-trees.

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.


 
Copyright © 1999-2024 SS64.com
Some rights reserved