Solved

SQL2K Merge Replication - is ADSL connection good enough?

Posted on 2004-07-30
3
258 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Get the latest status 8 32
SQL view 2 27
Insert query into temp tables using Coldfusion 3 22
IF THEN WITH A BEGIN END 4 8
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.

821 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