Export (0) Print
Expand All

How to Configure the Destination System for Log Shipping

You can use the following instructions to create a destination system for BizTalk Server log shipping that consists of one server for a single source system. If the destination system contains multiple servers, repeat the steps on each destination server.

Aa560961.Important(en-us,BTS.20).gifImportant
Always keep a copy of your backup files in a secure location. Even if you have log backups, you cannot restore your databases without the full backup files.

  • You must be logged on as a member of the BizTalk Server Administrators group to perform this procedure.

  • You must have the same version of SQL Server on both the source and destination systems. In addition, SQL Server must be installed in the same relative location on both the source and destination systems.

  • The directory for SQL transaction log (.LDF files) on the source system must also exist on the destination system. If this directory is not on the destination system, create the directory with the same name and permissions as on the source system.

  1. On the computer or computers that you have identified as the destination system, click Start, click Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio.

  2. In the Connect to Server dialog box, specify the name of the SQL Server on the destination computer, and then click Connect to connect to the appropriate SQL Server.

  3. In SQL Server Management Studio, click File, click Open, and then click File.

  4. In the Open File dialog box, browse to the following SQL script:

    %SystemRoot%\Program Files\Microsoft BizTalk Server 2006\Schema\LogShipping_Destination_Schema.sql
    
  5. Click the Query menu, and then click Execute.

    The LogShipping_Destination_Schema script drops and recreates the tables used for restoring the source databases on the destination system. This includes tables to store the list of databases being recovered, copies of the backup history imported from the source system's BizTalkMgmtDb database, and information about SQL Server Agent jobs configured to run against the source databases.

  6. In SQL Server Management Studio, click File, click Open, and then click File.

  7. In the Open File dialog box, browse to the following SQL script:

    %SystemRoot%\Program Files\Microsoft BizTalk Server 2006\Schema\LogShipping_Destination_Logic.sql
    
  8. Click the Query menu, and then click Execute.

  9. On the computer or computers you have identified as the destination system, click Start, click Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio.

  10. In the Connect to Server dialog box, specify the name of the SQL Server on the destination computer, and then click Connect to connect to the appropriate SQL Server.

  11. In SQL Server Management Studio, click New Query.

  12. In the query window paste the following command:

    exec bts_ConfigureBizTalkLogShipping @nvcDescription = '<MyLogShippingSolution>',
    @nvcMgmtDatabaseName = '<BizTalkServerManagementDatabaseName>',
    @nvcMgmtServerName = '<BizTalkServerManagementDatabaseServer>',
    @SourceServerName = null, -- null indicates that this destination server restores all databases
    @fLinkServers = 1 -- 1 automatically links the server to the management database
    
  13. In the command, replace <MyLogShippingSolution> with a meaningful description, surrounded by single quotes. Replace <BizTalkServerManagementDatabaseName> and <BizTalkServerManagementDatabaseServer> with the name and location of your source BizTalk Management database, surrounded by single quotes.

    Aa560961.Important(en-us,BTS.20).gifImportant
    Before you execute this statement, you must enable the Ad Hoc Distributed Queries configuration option on the destination system.

    Aa560961.note(en-us,BTS.20).gifNote
    If you have more than one source server, you can restore each source server to its own destination server. On each destination server, in the @SourceServerName = null parameter, replace null with the name of the appropriate source server, surrounded by single quotes (for example, @SourceServerName = 'MySourceServer',).

  14. Click the Query menu, and then click Execute.

    Aa560961.Important(en-us,BTS.20).gifImportant
    if the query fails, after you fix the problem with the query, you must start over from step 1 of this procedure to reconfigure the destination system.

    Aa560961.note(en-us,BTS.20).gifNote
    The restore jobs on the destination system will attempt to recreate the log and data files for each restored database in the same location as they existed on the source database server.

  15. On the destination system, in SQL Server Management Studio, double-click the appropriate server, double-click SQL Server Agent, and then double-click Jobs.

  16. In the details pane, you will see three new jobs:

    • BTS Log Shipping Get Backup History

      The BizTalk Server Log Shipping Get Backup History job moves backup history records from the source to the destination. It is scheduled by default to run every minute. This job runs as frequently as possible in order to move history records from the source to the destination. In the event of a system failure to the source system, the server that you identified as the destination system will continue to process the history records that have already been imported.

    • BTS Server Log Shipping Restore Databases

      The BizTalk Server Log Shipping Restore Databases job restores backup files for the given databases for the source to the destination server. It is scheduled by default to run every minute. This job runs continuously without completing as long as there are backup files to restore. As an extra precaution, you can run this job an additional time to ensure that it is complete.

    • BTS Log Shipping Restore To Mark

      The BizTalk Server Log Shipping Restore To Mark job restores all of the databases to a mark in the last log backup. This ensures that all of the databases are in a transactionally consistent state. In addition, this job re-creates all of the SQL Server Agent jobs on the destination system that had been on the source system.

    Aa560961.Important(en-us,BTS.20).gifImportant
    You should monitor these jobs to ensure that they do not fail.

  17. On a 32-bit system running BizTalk Server 2006, browse to the following folder: %SystemRoot%\Program Files\Microsoft BizTalk Server 2006\Schema\Restore.

    On 64-bit systems, browse to the following folder: %SystemRoot%\Program Files (x86)\Microsoft BizTalk Server 2006\Bins32\Schema\Restore.

  18. Right-click SampleUpdateInfo.xml, and then click Edit.

  19. Replace all instances of "SourceServer" with the name of the source system, and then replace all instances of "DestinationServer" with the name of the destination system.

    Aa560961.Important(en-us,BTS.20).gifImportant
    Include the quotation marks around the name of the source and destination systems.

    Aa560961.note(en-us,BTS.20).gifNote
    If you renamed any of the BizTalk Server databases, you must also update the database names as appropriate.

    Aa560961.note(en-us,BTS.20).gifNote
    If you have configured BAM, you must add two more lines in OtherDatabases section of the SampleUpdateInfo.xml file for the BAMAlertsApplication and BAMAlertsNSMain databases. If you changed the default name for these two databases, please use the actual database names.

    <Database Name="BAM Alerts Application DB" oldDBName="BAMAlertsApplication" oldDBServer="SourceServer" newDBName=" BAMAlertsApplication" newDBServer="DestinationServer"/>

    <Database Name="BAM Alerts Instance DB" oldDBName="BAMAlertsNSMain" oldDBServer="SourceServer" newDBName="BAMAlertsNSMain" newDBServer="DestinationServer"/>

  20. If you have more than one MessageBox database in your BizTalk Server system, add another MessageBoxDB line to the list, and then set IsMaster="0" for the non-master databases.

  21. If you are using BAM, HWS, or the Rules Engine, EDI, uncomment these lines as appropriate.

  22. If you have any custom databases, add them as appropriate under the <OtherDatabases> section. For more information, see How to Back Up Custom Databases.

  23. When you are finished editing the file, save it and exit.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft