You are implementing&

多项选择题 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

热门试题