移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

多选题

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?()

发布日期:2020-04-10

You are implementing transaction log shipping for ...
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

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!

此试题出现在

CMS专题

CMS专题

去刷题
热门试题热门资讯 相关试题

暂无相关推荐~