Database integrity describes the structural integrity of user and system tables and indexes in the database.
DBCC CHECKDB
Executes the following statements internally
- DBCC CHECKALLOC
- DBCC CHECKTABLE
- DBCC CHECKCATELOG
Checking Database Integrity can be accomplished by adding a check integrity task to a maintenance plan, or executing the DBCC CHECKDB Transact SQL statement.
This is a compulsory maintenance task which should be configured by a DBA on every hosted SQL Server Instance for every database.
