What should you do?

You have a database named db1 and an application named App1. App1 queries DB1.

You discover that a non-clustered index in obi is corrupt.

You need to repair the index- App1 must be able to query osi while the index is being repaired.

What should you do?
A . Run checkdb repair database and specify the repair_rebuild parameter.
B . Run checkdb repair database and specify the allon_oata_loss parameter.
C . Restore DB1 from a backup.
D . Drop and recreate the index.

View Answer

Answer: D