Note: Repair operations exclude any constraints applied to or between tables. Once the database becomes accessible, repair it using the minimum level of repair option. It also allows running DBCC CHECKDB repair options to resolve database corruption. The Emergency state allows accessing a database marked as suspect. However, if the backup is not available or is corrupted, you can try accessing the database in Emergency state. The best method to repair errors in the database, reported by DBCC CHECKDB, is to run the last known good backup as recommended by Microsoft. The failure of any of these checks will report consistency errors as part of the database console command. DBCC CHECKDB is used to check the physical and logical integrity of database objects, index relationships, and other structural checks.
