2. 计算机
  3. You are the administrator of three SQL Server 2000 computers at Five Lakes Publishing. One server, FLPSQL01, stores order data.

You are the administrator of three SQL Server 2000 computers at Five Lakes Publishing. One server, FLPSQL01, stores order data.

admin2009-05-19  10
问题 You are the administrator of three SQL Server 2000 computers at Five Lakes Publishing. One server, FLPSQL01, stores order data. You want to be able to use the other two servers, FLPSQL02 and FLPSQL03, to answer queries and run report. The planned network configuration is shown in the exhibit.


You want to use the database Maintenance Plan wizard to configure log shipping from FLPSQL01 to FLPSQL02 and FLPSQL03. You do not want users to add any new data on FLPSQL02 and FLPSQL03, but they must be able to run queries and reports.

Which two actions should you take? (Each correct answer presents part of the solution. Choose two)
选项 A、Set the database load state for each destination server to No recovery mode.
B、Set the database load state for each destination server to standby mode.
C、Enable the allow database to assume primary role option for both destination servers.
D、Enable the allow database to assume primary role option for one destination server and then disable this option for other destination server.
E、Disable the allow database to assume primary role option for both destination servers.
答案B,E
解析 Explanation:
B: A standby server can be maintained to take the place of the primary production server, if needed. A standby server is a secondary SQL Server installation that is kept up-to-date with a primary SQL Server installation through the application of transaction log backup files. You can automate the process of maintaining a standby server by creating backup, copy, and restore jobs that are periodically executed by SQL Server Agent on the primary server and on the standby server. This automated process is called log shipping. If you want the destination database to be viewable for read-only queries, you must select the Standby Mode option, the default is the No Recovery Mode option. The Standby mode specifies that the secondary database be made available for use, but in read-only mode.

E: We don’t want users to add any data on FLPSQL02 or FLPSQL03. Therefore we should disable the allow database to assume primary role option for them. If this option were enabled FLPSQL02 and FLPSQL03 would be able to be used as source servers.

Incorrect Answers:
A: The no recovery mode specifies that the secondary database be made unavailable for use. We need standby mode since we want FLPSQL02 and FLPSQL03 used for queries and reports.

Note: The active portion of the transaction log on the primary server can be backed up using the NORECOVERY backup option. This option leaves the primary database in recovery mode. When the primary server is ready to be brought back online, the transaction logs from the standby server (for the period that users were using the standby server as the primary server) can be applied to the primary server. This avoids the necessity of applying a complete database backup and all applicable transaction logs to restore the primary server. The result is a significant decrease in the time required to bring the primary server back online.

C: The primary role option must be disabled for both destination servers. If not they would be able to change and update data.

D: The primary role option must be disabled for both destination servers. If not they would be able to change and update data.
转载请注明原文地址:https://kaotiyun.com/show/WuhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)