SQL2K Merge Replication - is ADSL connection good enough?
Posted on 2004-07-30
I have got to get Merge Replication up and running on two servers. One is a web server hosted by a 3rd party on a very fast backbone connection. The other is in a local office on a 2meg ADSL connection (so 256kbits upload).
The database has around 50 tables - though there are 3 large ones with 500,000 - 1,000,000 records each. Most updates happen in the local office - with no more than 5,000 record updates / day. (rough data I know but should give an idea).
I ask because I got this working fine on a leased line (256 both ways) in the past - but am having several problems now and am on my second weekend attempt to get it to work. The first error this time has been:
"The subscription to publication 'myDb' is invalid"
This happened during the first push subscription from the local box to the webserver. Ive just restarted the push.
Generally speaking would the ADSL connection be up to the task? Is it recommended / reliable enough to use ADSL for Replication?