You are implementing transaction log shipping for a database named DB1 from a server named SQL1 to a server named SQL2. Because DB1 is 100 GB in size, it is too big to transfer over the network in a reasonable amount of time. You need to minimize the impact on the network while you initialize the secondary database. Which two actions should you perform?()
- A、Specify the simple recovery model for DB1.
- B、Specify either the full or the bulk-logged recovery model for DB1.
- C、Perform a complete backup of DB1 to portable media. Restore the secondary database from that backup; specify the RECOVERY option.
- D、Perform a complete backup of DB1 to portable media. Restore the secondary database from that backup; specify the STANDBY option.
- E、Before you activate transaction log shipping to the secondary database, execute the following statement on the primary server.BACKUP LOG DB1 WITH TRUNCATE ONLY
正确答案:B,D
答案解析:有
![](/editor/images/201705/qrcode_for_gh_573e2a458573_258.jpg)
微信扫一扫手机做题