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

微软认证考试

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

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup.  So what action should you perform to achieve this goal?()  

  • A、You should recreate the indexes. 
  • B、You should compress the log file backups 
  • C、You should make the Dworks database use the Full recovery mode 
  • D、You should make the Dworks database use the Simple recovery mode.
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题