多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题