Provisioning SQL Databases — Question 6

You have a database named DB1.
You discover that DB1 is corrupt.
You run DBCC CHECKDB and receive an error message within a few seconds. No pages are listed in the error message.
You need to repair the database corruption as quickly as possible. The solution must minimize data loss.
What should you do?

Answer options

• A. Run DBCC CHECKDB (‘db1’, REPAIR_ALLOW_DATA_LOSS).
• B. Run DBCC CHECKDB (‘db1’, REPAIR_FAST).
• C. Delete the transaction logs and restart the Microsoft SQL Server instance.
• D. Run DBCC CHECKDB (‘db1’, REPAIR_REBUILD).
• E. Restore the database from a backup.

Correct answer: C

Explanation

The correct answer is C because deleting the transaction logs can sometimes resolve corruption issues quickly, albeit at the risk of data loss. Options A and D involve repairs that could lead to further data loss, while B is not a valid option for repairs, and E would take longer due to the restore process, which may not minimize data loss as effectively as option C.