You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. AIOTestKing A 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 AIOTestKing As network utilization becomes excessive after the nightly maintenance tasks are complete. You need to reduce the network bandwidth utilization for AIOTestKing A.
What should you do?
A.
Disable log shipping before the nightly maintenance. Re-enable log shipping after nightly maintenance completes.
B.
Configure the database to use the bulk-logged recovery model.
C.
Increase the time between transaction log backups.
D.
Each night, rebuild only those indexes that require it.
Explanation:
Every rebuilt index will also be rebuilt on the recipient of the Log shipping. Only rebuild the logs that needs to be rebuilt in order to minimize the logs that are shipped to the remote server.