You are a database administrator for AIOTestKing.com. Each night, you perform full backups of your SQL Server 2005 computer. During business hours, you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do?
A.
Schedule an additional transaction log backup to run after the nightly index is rebuilt.
B.
Schedule a marker to be added to the transaction log before the nightly index is rebuilt.
C.
Schedule the full backups to run after the nightly index is rebuilt.
D.
Schedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.
Explanation:
If the index rebuild is done after the full backup, the transaction log backups will be unnecessary large.