试题详情
- 多项选择题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
关注下方微信公众号，在线模考后查看
热门试题