What should you do?

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.

View Answer

Answer: A

Explanation:

References: http://technet.microsoft.com/en-us/library/ms187048.aspx