PrepAway - Latest Free Exam Questions & Answers

You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size. The Sales dat

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 Sales_2.ndf is corrupt. You need to recover the corrupted data in the minimum amount of time. What should you do?

A. Perform a file restore.

B. Perform a transaction log restore.

C. Perform a restore from a full backup.

D. Perform a file group restore.

Explanation:


Leave a Reply