多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

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.
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题