CHECKDB

What is CHECKDB?

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

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.

Find out How we work with Site Reliability >

Find out How we work with Data and analytics >

Read about: Have you secured your database environment well enough against data loss and downtime?

Read about: How does your company cope with a data crash?