You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size. The Sales database is c
Posted: Mon Oct 17, 2022 4:47 pm
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.
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?
- You Administer 1 (46.72 KiB) Viewed 102 times
B. Perform a transaction log restore.
C. Perform a restore from a full backup.
D. Perform a filegroup restore.