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?
A.
Perform a restore from a full backup.
B.
Perform a transaction log restore.
C.
Perform a file restore.
D.
Perform a filegroup restore.
Explanation:
Reference:
http://technet.microsoft.com/en-us/library/ms187048.aspx