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.
0
0
A
Perform a restore from full back up
0
0
C, because “minimum amount of time”
0
0
what is the correct answer?
0
0
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.
0
0
Should Be C. because of the fact it said minimal amount of time!
1
0