CHECKDB is a Database Console Command (DBCC) and it is used to identify errors in the SQL Server database. The DBCC CHECKDB comes with three repair options to fix database-related errors. DBCC CHECKDB checks the physical and logical integrity of database objects, index relationships, and other structural checks. The failure of any of these checks will report consistency errors as part of the database console command.
CHECKDB checks the integrity of all the objects in the specified database by performing the following operations:
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
DBCC CHECKDB applies to all supported versions of SQL Server , Azure SQL Database and Azure SQL Managed Instance.
Cegal and CHECKDB
Cegal possesses a very high level of expertise relating to many different database technologies, including Microsoft SQL, Oracle, PostgreSQL, MySQL, MongoDB, and NoSQL. Our service Restore Test as a Service is a double verification service - it verifies both the integrity of the SQL Database, and it also verifies if the DB Backup can be restored and run if a disaster occurs and the database environment must be restored.