July 21, 2005 at 1:57 am
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
July 22, 2005 at 4:28 am
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
May 16, 2012 at 12:23 pm
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.
May 17, 2012 at 1:32 am
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