Youareadatabaseadministratorforyourcompany.Eachnight，youperformfullbackupsofyourSQLServer2005computer.Duringbusinesshours，youperformhourlytransactionlogbackups.Yourebuilddatabaseindexeseachnight.Youneedtomodifyyourbackupstrategy.Youmustensurethatthedatabaserecoverstoanewserverasquicklyaspossible.Whatshouldyoudo？（）A.Schedule the full backups to run after the nightly index is rebuilt.B.Schedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.C.Schedule an additional transaction log backup to run after the nightly index is rebuilt.D.Schedule a marker to be added to the transaction log before the nightly index is rebuilt.

单项选择题

You are a database administrator for your company. 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 the full backups to run after the nightly index is rebuilt.
B.Schedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.
C.Schedule an additional transaction log backup to run after the nightly index is rebuilt.
D.Schedule a marker to be added to the transaction log before the nightly index is rebuilt.

MCITP(70-444)