[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL2K Merge Replication - is ADSL connection good enough?

Posted on 2004-07-30
3
Medium Priority
?
268 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 400 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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

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…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

607 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