Tag Archives: Database integrity

SQL Server – Checking Database Integrity

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 [...]