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?
ThanksJohn
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
