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?

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.

Explanation:

A page restore is intended for repairing isolated damaged pages. Restoring and recovering a few individual pages might be faster than a file restore, reducing the amount of data that is offline during a restore operation.

RESTORE DATABASE WITH PAGE

Restores individual pages. Page restore is available only under the full and bulk-logged recovery models.

References: https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql