PrepAway - Latest Free Exam Questions & Answers

You need to recover the corrupted data in the minimum a…

You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size.The Sales database is configured as shown in the following table.

You discover that all files except Sales_2.ndf are corrupt.
You need to recover the corrupted data in the minimum amount of time.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Perform a file restore.

B.
Perform a transaction log restore.

C.
Perform a restore from a full backup.

D.
Perform a filegroup restore.

Explanation:
In a file restore, the goal is to restore one or more damaged files without restoring the whole database.
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/file-restores-simplerecovery-model


Leave a Reply