How Implement BizTalk Server Log Shipping?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How Implement BizTalk Server Log Shipping?

Viewing 2 reply threads
  • Author
    Posts
    • August 27, 2009 at 1:24 PM #23134
      community-content

        Hi,

        I’m SQL DBA maintaining BizTalk Databases in SQL Server 2005.

        We have SQL Server 2005 and has 3 instances for serving BizTalk Apllication, INS1, INS2 and INS3

         INS1 has BizTalkMsgBoxDb database

        INS2 has BizTalkDTADb database

        INS3 has BizTalkMgmtDb and SSODB databases

        I went thorugh BOL http://msdn.microsoft.com/en-us/library/cc296856%28BTS.10%29.aspx. I understood that if we using the BizTalk Application builtin backup job Backup BizTalk Server (BizTalkMgmtDb) then only we can use BizTalk Server Log Shipping.

        But out of the 3 instances, only INS2 has the builtin backup job Backup BizTalk Server (BizTalkMgmtDb). So I can use this job to backup BizTalkDTADb database, which is in INS2. But,how can we use the Built in Backup job to backup to backup the databases in INS1 & INS3 and configure BizTalk Log Shipping?

        Right now I’m using my regular backup script to backup the databases in all 3 instances. But MS recommeds to use BizTalk Log shipping instaed of SQL Server Log shipping?

        Anybody implemented BizTalk Log shipping in SQL Server 2005, please advice me

        Thanks

      • August 30, 2009 at 12:44 PM #23159
        community-content

          Could you please advice me..

        • August 31, 2009 at 3:45 AM #23167
          community-content

            I think this will be helpful.

            http://msdn.microsoft.com/en-us/library/aa560961(BTS.10).aspx

             

            Thank you,

            Nandika

        • Author
          Posts
        Viewing 2 reply threads
        • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.