locked
BizTalk Log Shipping RRS feed

  • Question

  • Hi,

    I have 2 SQL Server Clusters -

    Cluster 1 has BizTalk MsgBox, BizTalk Mgmt  database

    and Cluster 2 has BizTalk DTA DB

    Now, I need to setup Log shipping. For destination server do I need only 1 SQL Server or do I need 1 SQL Cluster or 2 Sql Clusters.

    Regards,

    Sharmishtha

    Tuesday, May 16, 2017 1:02 PM

Answers

  • you can use 1, 2 or more servers in the DR setup.


    Tuesday, May 16, 2017 5:59 PM
    Moderator
  • Hi,

    It is possible to log ship the two databases to two different DR db servers or you can ship them to a single target DR server both approach work fine.


    Mandar Dharmadhikari

    • Marked as answer by Sharmishtha Wednesday, May 17, 2017 3:15 AM
    Wednesday, May 17, 2017 12:16 AM
    Moderator

All replies

  • You can log ship each database to a different target so you can use 1, 2 or more servers in the DR setup.

    Once you go through the process in TEST, you'll see.

    Tuesday, May 16, 2017 3:38 PM
    Moderator
  • so, if I have 2 sql clusters in source, I can have only 1 sql server ( not cluster ) in the destination.

    Tuesday, May 16, 2017 5:10 PM
  • you can use 1, 2 or more servers in the DR setup.


    Tuesday, May 16, 2017 5:59 PM
    Moderator
  • Hi,

    It is possible to log ship the two databases to two different DR db servers or you can ship them to a single target DR server both approach work fine.


    Mandar Dharmadhikari

    • Marked as answer by Sharmishtha Wednesday, May 17, 2017 3:15 AM
    Wednesday, May 17, 2017 12:16 AM
    Moderator
  • Was there something wrong with my Answer?
    Wednesday, May 17, 2017 11:34 AM
    Moderator