Solved

SQL2K Merge Replication - is ADSL connection good enough?

Posted on 2004-07-30
3
262 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
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…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

707 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