You need to recover the corrupted data in the minimum amount of time

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?

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 filegroup restore.

Explanation:
Reference:
http://technet.microsoft.com/en-us/library/ms187048.aspx
http://msdn.microsoft.com/en-us/library/aa337540.aspx



Leave a Reply 1

Your email address will not be published. Required fields are marked *


John

John

A seems to be correct.