The first, best solution if DBCC CHECKDB reports consistency errors is to restore from a known good backup. However, if you cannot restore from a backup, then CHECKDB provides a feature to repair errors. If system level problems such as the file system or hardware may be causing these problems, it is recommended you correct these first before restoring or running repair.

When you run DBCC CHECKDB a recommendation is provided to indicate what the minimum repair option that is required to repair all errors. These messages may look something like the following:

CHECKDB found 0 allocation errors and 15 consistency errors in database 'mydb'. repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (mydb)