Provisioning SQL Databases — Question 50

You have a database named DB1 that uses simple recovery mode.
Full backups of DB1 are taken daily and DB1 is checked for corruption before each backup.
There was no corruption when the last backup was complete.
You run the sys.columns catalog view and discover corrupt pages.
You need to recover the database. The solution must minimize data loss.
What should you do?

Answer options

• A. Run RESTORE DATABASE WITH RECOVERY.
• B. Run RESTORE DATABASE WITH PAGE.
• C. Run DBCC CHECKDB and specify the REPAIR_ALLOW_DATA_LOSS parameter.
• D. Run DBCC CHECKDB and specify the REPAIT_REBUILD parameter.

Correct answer: B

Explanation

The correct answer is B, as using RESTORE DATABASE WITH PAGE allows for the recovery of specific corrupted pages while retaining the rest of the data, thereby minimizing data loss. Option A is incorrect because it does not address the corruption issue. Option C could lead to significant data loss due to the REPAIR_ALLOW_DATA_LOSS parameter, which is not desirable. Option D, while it may fix some issues, does not specifically target the corruption in pages as needed.