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?()
- ASpecify the simple recovery model for DB1.
- BSpecify either the full or the bulk-logged recovery model for DB1.
- CPerform a complete backup of DB1 to portable media. Restore the secondary database from that backup; specify the RECOVERY option.
- DPerform a complete backup of DB1 to portable media. Restore the secondary database from that backup; specify the STANDBY option.
- EBefore you activate transaction log shipping to the secondary database, execute the following statement on the primary server.BACKUP LOG DB1 WITH TRUNCATE ONLY