Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication/Log Shipping across a firewall Expand / Collapse
Author
Message
Posted Thursday, July 21, 2005 1:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:24 AM
Points: 5,387, Visits: 9,969

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

Post #202996
Posted Friday, July 22, 2005 4:28 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, February 20, 2014 3:40 AM
Points: 91, Visits: 10

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

Post #203437
Posted Wednesday, May 16, 2012 12:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 16, 2012 12:56 PM
Points: 1, Visits: 3
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.
Post #1301277
Posted Thursday, May 17, 2012 1:32 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:24 AM
Points: 5,387, Visits: 9,969
Please start a new thread. People are less likely to be looking at a seven-year old topic than a new one.

John
Post #1301525
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse