SQL consistency check errors

If you are backing up an SQL server, it's advisable to perform a consistency check as part of the backup. When this check fails, it can be hard to work out why, so you can run a check manually. These instructions are for SQL Server 2005.

  • Open SQL Management Studio and connect to the SQL server.
  • Browse to the database which is reporting consistency check errors
  • Ensure the database is highlighted in the Object Explorer pane.
  • Click the New Query button.
  • In the pane which opens, enter DBCC CHECKDB
  • Click Execute (or press F5)
  • The check may take a little while to run. The results are displayed in the Messages window.
  • If the check completed successfully, the messages should end with CHECKDB found 0 allocation errors and 0 consistency errors in database 'TestDB'.

This process was derived from the Microsoft Technet article at http://msdn2.microsoft.com/en-us/library/aa258278(SQL.80).aspx which also lists the test carried out.