|
SQL consistency check errors |
|
Written by Hywel Mallett
|
|
Tuesday, 24 April 2007 |
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. |