PrepAway - Latest Free Exam Questions & Answers

You need to ensure that no suspect pages have been detected in your database

You administer a Microsoft SQL Server 2008 R2 instance.
You need to ensure that no suspect pages have been detected in your database.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Execute sp_helpfile.

B.
Execute DBCC CHECKDB.

C.
Examine the msdb..suspect_pagestable.

D.
Execute DBCC CHECKDBalong with the REPAIR_FASTclause.

E.
Execute DBCC CHECKDBalong with the REPAIR_REBUILDclause.

F.
Restore the database from the most recent full backup. Apply any differential and log
backups.

G.
Use the ALTER DATABASEstatement along with the SET EMERGENCYclause.

H.
Use the RESTORE DATABASEstatement along with the PAGESclause. Create a new log
backup. Apply all differential and log backups, including the most recent backup.

I.
Use the RESTORE DATABASEstatement along with the PAGESclause. Apply any
differential and log backups. Create a new log backup and then restore the new log backup.


Leave a Reply