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 exceptSales_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.
If you wish for to get a good deal from this
piece of writing then you have to apply such techniques to
your won website.
A
Perform a restore from full back up
C, because “minimum amount of time”
what is the correct answer?
the answer should be C due to the fact it said minimal amount of time.
Doing a Full back up restore takes time, but it is correct you can do a full backup restore but that wont achieve the goal of this question which is to restore it in the minimal amount of time.
Should Be C. because of the fact it said minimal amount of time!