Hi viewers, today I am going to provide some clarification about DBCC CHECKDB.
Generally DBA's are using this command to check the database health check.
DBCC CHECKDB:
Runs DBCC CHECKALLOC on the database.
Runs DBCC CHECKTABLE on every table and view in the database.
Runs DBCC CHECKCATALOG on the database.
Validates the contents of every indexed view in the database.
Validates link-level consistency between table metadata and file system directories and files when storing varbinary(max) data in the file system using FILESTREAM.
Validates the Service Broker data in the database.
REPAIR_ALLOW_DATA_LOSS:
Tries to repair all reported errors. These repairs can cause some data loss.
REPAIR_FAST:
Maintains syntax for backward compatibility only. No repair actions are performed.
REPAIR_REBUILD:
REPAIR_REBUILD does not repair errors involving FILESTREAM data
-- by Shivasagar V
Generally DBA's are using this command to check the database health check.
DBCC CHECKDB:
Runs DBCC CHECKALLOC on the database.
Runs DBCC CHECKTABLE on every table and view in the database.
Runs DBCC CHECKCATALOG on the database.
Validates the contents of every indexed view in the database.
Validates link-level consistency between table metadata and file system directories and files when storing varbinary(max) data in the file system using FILESTREAM.
Validates the Service Broker data in the database.
REPAIR_ALLOW_DATA_LOSS:
Tries to repair all reported errors. These repairs can cause some data loss.
REPAIR_FAST:
Maintains syntax for backward compatibility only. No repair actions are performed.
REPAIR_REBUILD:
REPAIR_REBUILD does not repair errors involving FILESTREAM data
-- by Shivasagar V
No comments:
Post a Comment