Solved

SQL2K Merge Replication - is ADSL connection good enough?

Posted on 2004-07-30
3
259 Views
Last Modified: 2012-08-13
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?
0
Comment
Question by:niico
  • 2
3 Comments
 
LVL 34

Accepted Solution

by:
arbert earned 100 total points
ID: 11682998
I would say, based on your 5000 record estimate, the speed should be fine.  I would imagine you might experience timeouts and problems on the original setup, but after you get the push done, I wouldn't expect too many problems.

Are these servers directly connected to the internet (gasp), or are you going through some kind of tunnel or VPN?
0
 

Author Comment

by:niico
ID: 11683667
thanks

they're not in a vpn - but a firewall blocks access to the sql servers unless from a safe IP. We are also planning to introduce a VPN in the future.

actually it ended up transferring fine - my problem oroginally was that I hadnt set an alias name for the server (was using an IP).

0
 
LVL 34

Expert Comment

by:arbert
ID: 11684814
Glad you got it working...Nice to see someone is not just putting their server directly on the net as well :)`
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question