SQL Server – Checking Database Integrity

Leave a comment (0) Go to comments

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.

EOF - SQL Server – Checking Database Integrity, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.