Replication/Log Shipping across a firewall

  • Hello

    We're trying to decide between transactional replication and log shipping, and I think it's going to come down to how easy it will be for the two servers to communicate.  For log shipping we will need for one server to map a drive to the other, meaning the account that starts the service on one server needs permissions to a share on the other - not easy to set up if there are firewall policies to overcome and no trusted domains between the two.

    As I understand it, transactional replication only needs port 1433 to be open on the firewall for the two servers to communicate (or three if we use a separate Distributor).  Am I right in this?

    Second, I have read that replication generates more network traffic than log shipping.  Is there any way of quantifying this?

    Thanks

    John

  • If you have a firewall and fixed IP at both ends, configure a VPN between the two sites.

    you can safely open ports between the two sites without exposing your SQL servers to the outside world.

    I have this set up between three sites (one site trans repl to two)

    HTH

  • We have a VPN connection between us and our Vendor, can I use transactional log shipping between the sites? is there anything I need to consider as part of the process? please advice.

  • Please start a new thread. People are less likely to be looking at a seven-year old topic than a new one.

    John

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply