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.