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 file restore.
B. Perform a transaction log restore.
C. Perform a restore from a full backup.
D. Perform a filegroup restore.
This is a really bad scenario for the organization. since only one of the secondary files is undamaged, it would be best to restore the full backup of the sales database.
the correct answer should be C
A 3TB database will not restore in the minimum amount of time.
I think A is the correct answer in this case.