题目内容

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

查看答案
更多问题

变电站应具备哪些记录薄?

形成动机的主要因素包括()。

A. 需要
B. 兴趣
C. 理想
D. 信念
E. 诱因

设计者对文化的继承,有以下方式()

A. 原创性
B. 延续性
C. 复合性
D. 反复性
E. 趣味性

简述史诗《格萨尔》载体――说唱艺人的种类?

答案查题题库