You are a database administrator for AIOTestKing.com. You notice that one of the data files on a SQL Server 2005 computer is corrupted. You need to restore the database from the most recent set of backups. You want to perform this task as quickly as possible, with a minimum loss of data. What should you do first?
A.
Restore the most recent transaction log backup.
B.
Restore the most recent full database backup.
C.
Perform a full database backup.
D.
Perform a transaction log backup.
Explanation:
In order to restore from the most recent set of backups, you have to first ensure that you can restore all transactions that have occurred between the time of the backup and the time when the database went corrupt. In order to accomplish this you should backup the transaction log.