问题:
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
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?()
● 参考解析
本题暂无解析