YouaretheadministratorofaSQLServer2005computernamedSQL1.SQL1containsadatabasethatutilizesSQLServerlogshipping.Logshippingoccursevery30minutes.Eachnight，afullbackupismadeofthedatabase，andalldatabaseindexesarerebuilt.Thecompany’snetworkadministratorreportsthatSQL1snetworkutilizationbecomesexcessiveafterthenightlymaintenancetasksarecomplete.YouneedtoreducethenetworkbandwidthutilizationforSQL1.Whatshouldyoudo？（）A.Configure the database to use the bulk-logged recovery model.B.Each night， rebuild only those indexes that require it.C.Disable log shipping before the nightly maintenance. Re-enable log shipping after nightly maintenance completes.D.Increase the time between transaction log backups.

单项选择题

You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 contains a database that utilizes SQL Server log shipping. Log shipping occurs every 30 minutes. Each night， a full backup is made of the database， and all database indexes are rebuilt. The company’s network administrator reports that SQL1s network utilization becomes excessive after the nightly maintenance tasks are complete. You need to reduce the network bandwidth utilization for SQL1. What should you do？（）

A.Configure the database to use the bulk-logged recovery model.
B.Each night， rebuild only those indexes that require it.
C.Disable log shipping before the nightly maintenance. Re-enable log shipping after nightly maintenance completes.
D.Increase the time between transaction log backups.

MCITP(70-444)