replication via internet (T-1) -- sql server replication

Doug
7/30/2003 12:49:00 PM

Does anyone out there have any experience with
Replication over vpn between 2 offices (T1 line). I'm
wondering if setting up transactional rep for a db ~17gb
in size would work consistently, or if log shipping would
be a better option. Trans logs for a typical weekday are
around 300-500mb/day (assuming one log file, which I'd
use more for setting this up).

I've set it up before, but it was over a lan, and didn't
have bandwidth issues.

Thanks in advance,

Hilary Cotter
7/30/2003 9:34:16 PM

I did a 10 Gig database. The problem is deploying your initial snapshot. It
should be done via tape or some other method of shipping it to the
subscriber. Replicating such a large volume of data over the wire is
problematic.
Log shipping requires that you start with a base backup being applied to the
standby server - so you are running into the same initial deployment
problem.
[quoted text, click to view]

sql server replication : replication via internet (T-1)