可学答题网 > 问答 > MCTS(70-431)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You are implementing t


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

  • ASpecify the simple recovery model for DB1.
  • BSpecify either the full or the bulk-logged recovery model for DB1.
  • CPerform a complete backup of DB1 to portable media. Restore the secondary database from that backup; specify the RECOVERY option.
  • DPerform a complete backup of DB1 to portable media. Restore the secondary database from that backup; specify the STANDBY option.
  • EBefore you activate transaction log shipping to the secondary database, execute the following statement on the primary server.BACKUP LOG DB1 WITH TRUNCATE ONLY
参考答案
参考解析:
分类:MCTS(70-431)题库
相关推荐

1、You are implementing a

You are implementing an ASP.NET Web site that uses a custom server control named Task. Tas...

2、You are implementing a

You are implementing an ASP.NET application. You add the following code segment.You need to add...

3、You are implementing a

You are implementing a very simple TCP/IP network. It rarely changes and you would like to...

4、You are implementing a

You are implementing an ASP.NET MVC 2 Web application that contains several folders. The Views/...

5、You are implementing a

You are implementing an ASP.NET application that will use session state in out-of-proc mode. Yo...

6、You are implementing a

You are implementing an ASP.NET Web site. The site allows users to explicitly choose the d...