How to Run DBCC CHECKDB to Check SQL Database Integrity
'Database Console Command CHECKDB (DBCC CHECKDB)is used to check the integrity (physical & logical) of objects in a SQL Server database.The command is supported in databases that contain memory-optimized tables but the validation is only supported in disk-based tables. The DBCC repair option is unavailable in memory-optimized tables and therefore, leads to the need of regular database backup.In case an issue arises in a memory-optimized table, the data can be restored from the last backup done.
The various operations that are performed by CHECKDB are:
-
DBCC CHECKALLOC execution on SQL database.
-
DBCC CHECKTABLE execution on each table and view of SQL database.
-
DBCC CHECKCATALOG execution on SQL database.
-
Validation of content in the indexed view of the database.
-
Validation of link-level consistency amidst the file directories and the table metadata.
-
Validation of service broker data.
Since DBCC CHECKDB runs all the other commands it will not be necessary to run CHECKALLOC, CHECKTABLE and CHECKCATALOG commands separately.
DBCC CHECKDB Syntax
Trackbacks
Die Kommentarfunktion wurde vom Besitzer dieses Blogs in diesem Eintrag deaktiviert.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt