在 Lync Server 2013 中為 Persistent Chat Server 主資料庫設定 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 連線至 Persistent Chat Server 次要記錄傳送資料庫實例,並確定 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 連線至 Persistent Chat 主要資料庫實例,請執行下列步驟: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.