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’.