在 Lync Server 2013 中为持久聊天服务器主数据库设置 SQL Server 日志传送Setting up SQL Server Log Shipping in Lync Server 2013 for the Persistent Chat Server primary database

 

上次修改的主题: 2012-11-12Topic Last Modified: 2012-11-12

使用 SQL Server Management Studio 连接到持久聊天服务器辅助日志传送数据库实例,并确保 SQL Server 代理正在运行。Using SQL Server Management Studio, connect to the Persistent Chat Server secondary Log Shipping database instance, and be sure that SQL Server Agent is running.

若要使用连接到持久聊天主数据库实例的 SQL Server Management Studio,请执行以下步骤:Using SQL Server Management Studio connected to the Persistent Chat primary database instance, perform the following steps:

  1. 请确保 SQL Server 代理正在运行。Be sure that the SQL Server Agent is running.

  2. 右键单击 mgc 数据库,然后单击“属性”****。Right-click the mgc database, and then click Properties.

  3. 在“选择页”**** 下,单击“事务日志传送”****。Under Select a page, click Transaction Log Shipping.

  4. 选中“将此数据库启用为日志传送配置中的主数据库”**** 复选框。Select the Enable this as a primary database in a log shipping configuration check box.

  5. 在“事务日志备份”**** 下,单击“备份设置”****。Under Transaction log backups, click Backup Settings.

  6. 在“备份文件夹的网络路径”**** 框中,键入您为事务日志备份文件夹创建的共享的网络路径。In the Network path to the backup folder box, type the network path to the share that you created for the transaction log backup folder.

  7. 如果备份文件夹位于主服务器上,则在 "如果备份文件夹位于主服务器上" 中键入备份文件夹的本地路径 **,请键入文件夹的本地路径 (例如: c: \ backup) ** 框。If the backup folder is located on the primary server, type the local path to the backup folder in the If the backup folder is located on the primary server, type a local path to the folder (example: c:\backup) box. (如果备份文件夹不在主服务器上,则可以将此框保留为空。 ) (If the backup folder is not on the primary server, you can leave this box empty.)

    重要

    如果主服务器上的 SQL Server 服务帐户在本地系统帐户下运行,则必须在主服务器上创建备份文件夹,并指定该文件夹的本地路径。If the SQL Server service account on your primary server runs under the local system account, you must create your backup folder on the primary server and specify a local path to that folder.

  8. 配置“删除文件,如果其保留时间超过”**** 和“在以下时间内没有执行备份时报警”**** 参数。Configure the Delete files older than and Alert if no backup occurs within parameters.

  9. 查看“备份作业”**** 下的“计划”**** 框中所列的备份计划。Look at the backup schedule listed in the Schedule box under Backup job. 若要自定义安装计划,请单击 " 计划",然后根据需要调整 SQL Server 代理计划。To customize the schedule for your installation, click Schedule, and adjust the SQL Server Agent schedule as required.

  10. 在“压缩”**** 下,选择“使用默认服务器设置”****,然后单击“确定”****。Under Compression, select Use the default server setting, and then click OK.

  11. 在“辅助服务器实例和数据库”**** 下,单击“添加”****。Under Secondary server instances and databases, click Add.

  12. 单击 " 连接 ",然后连接到已配置为辅助服务器的 SQL Server 实例。Click Connect and connect to the instance of SQL Server that you have configured as your secondary server.

  13. 在“辅助数据库”**** 框中,从列表中选择“mgc”**** 数据库。In the Secondary Database box, select the mgc database from the list.

  14. 在 " 初始化辅助数据库 " 选项卡上,依次选择 " **是"、"生成主数据库的完整备份并将其还原到辅助数据库中" (并创建辅助数据库(如果) 中不存在) **。On the Initialize Secondary database tab, choose the option Yes, generate a full backup of the primary database and restore it into the secondary database (and create the secondary database if it doesn't exist).

  15. 在“复制文件”**** 选项卡上的“复制文件的目标文件夹”**** 框中,键入应将事务日志备份复制到的文件夹的路径。此文件夹通常位于辅助服务器上。On the Copy Files tab, in the Destination folder for copied files box, type the path of the folder into which the transaction logs backups should be copied. This folder is often located on the secondary server.

  16. 注意“复制作业”**** 下的“计划”**** 框中列出的复制计划。Note the copy schedule listed in the Schedule box under Copy job. 若要自定义安装计划,请单击 " 计划",然后根据需要调整 SQL Server 代理计划。To customize the schedule for your installation, click Schedule, and adjust the SQL Server Agent schedule as required. 此计划应与备份计划大致相同。This schedule should be approximately the same as the backup schedule.

  17. 在“还原”**** 选项卡上的“还原备份时的数据库状态”**** 下,选择“无恢复模式”**** 选项。On the Restore tab, under Database state when restoring backups, choose the No recovery mode option.

  18. 在“延迟还原备份操作至少:”**** 下,选择“0 分钟”****。Under Delay restoring backups at least:, select 0 minutes.

  19. 在“在以下时间内没有执行还原时报警”**** 下选择报警阈值。Choose an alert threshold under Alert if no restore occurs within.

  20. 查看“还原作业”**** 下的“计划”**** 框中列出的还原计划。Look at the restore schedule listed in the Schedule box under Restore job. 若要自定义安装计划,请单击 " 计划",根据需要调整 SQL Server 代理计划,然后单击 "确定"To customize the schedule for your installation, click Schedule, adjust the SQL Server Agent schedule as required, and click OK. 此计划应与备份计划大致相同。This schedule should be approximately the same as the backup schedule.

  21. 在“数据库属性”**** 对话框中,单击“确定”**** 开始配置过程。On the Database Properties dialog box, click OK to begin the configuration process.