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

微软认证考试

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

Your company uses a mission-critical database named DB1, which is located on a server named SQL1. You want to mirror DB1 on a second server named SQL2. Before you can establish database mirroring, you need to prepare DB1 and the servers for mirroring. Which three actions should you perform?()

  • A、 Set the recovery model of DB1 on SQL1 to bulk-logged recovery. 
  • B、 Set the recovery model of DB1 on SQL1 to full recovery. 
  • C、 Back up DB1 on SQL1. Restore the backup on SQL2; specify the NORECOVERY option. 
  • D、 Back up DB1 on SQL1. Restore the backup on SQL2; specify the STANDBY option. 
  • E、 Back up DB1 on SQL1. Restore the backup on SQL2; specify the RECOVERY option.
  • F、 Create endpoints on all participating servers. 
  • G、 Set the AutoShrink property of DB1 on SQL1 to false.
正确答案:B,C,F
答案解析:
进入题库查看解析

微信扫一扫手机做题