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
答案解析:有

微信扫一扫手机做题