473,224 Members | 1,685 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 software developers and data experts.

SQL server replication from non-clustered database servers

Hello,

Being a bit of a SQL Server novice, need some advice with the following
situation.

Server A and Server B have SQLServer 2000 based databases. The vendor
of the application/system has implemented their own replication process
to ensure the 2 databases are in sync. However, there is no clustering
with virtual IP addresses implemented. So to an external client/db, it
is 2 identical databases with the same name on 2 distinct servers.

We need to develop an application that will reside on a networked
server C and with SQLServer 2000 as well. While most of the tables in
this database are self contained, around 10 tables will have to be
mirror copies of the same tables from either Server A or Server B.

Question, how do we implement subscription based replication on top of
a redundant database, when no clustering is implemented? So, in
essence, when Server A is alive, the database on Server C will
periodically (or on change) replicate the 10 tables from Server A. When
Server A is not alive, it needs to do same from server B. (When both
server A and B are alive, it is acceptable to get data from either,
since they are synchronized internally).

Any alternate suggestions on achieving this functionality are welcome
too. If SQL Server 2005 has some capabilities that may address this
problem, that is a consideration as well.

Thanks

Jun 22 '06 #1
1 1525
Pls take a look at Alternate Synchronization Partners in merge replication.
On SQL Server 2005 you might consider peer-to-peer transactional
replication.
Actually probably the simplest solution is to have Server C as a publisher
and the other 2 as subscribers in a merge scenario.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Jun 22 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Stein Rustad | last post by:
Is it possible to set up replication on a shared mySQL server, i.e. have the replication only concern the databases that I have access to, without changing the entire server setup? (This will...
0
by: Lucky | last post by:
hi, i'm testing replication on ms sql server 2000 sp4 "Developer Edition". i've created replication succesfully using 2 different server now i want to check that if the main server crshes how can...
14
by: diskoduro | last post by:
Hi!! Years ago I built a database to control the production of a little factory. The users wanted to work in a Windows Net workgroup so I created an mdb with all the tables and data an after...
7
by: Paul Aspinall | last post by:
Hi I have an application which runs on a desktop. I want to synchronise the DB with a PDA app, which also uses SQL Server 2005 (mobile and express). I believe that I will need to write my own...
1
by: loosecannon_1 | last post by:
All my queries are being blocked while the tables are being replicated and it is causing some 2 minute blocking. Is there a way for the Replication to allow dirty reads because I really don't...
4
by: John | last post by:
Hi Is there a way to synchronise/replicate an access db with sql server 2000 db, short of writing the code oneself? Thanks Regards
4
by: gjameson via AccessMonster.com | last post by:
I am nearing the end of my development for my application. Here is my scenario. A few users will use this on the lan. ---- FE BE ----Security A few users will use this out in the field and...
15
by: sat | last post by:
i have seen the check status then it is showing like : Type Of Thread Status HoldL Resting Admin Thread Resting Worker Thread ...
0
by: tsharp89 | last post by:
We currently have SQL Server 2000 and have merge replication. We have the following process 1. Data is transfered to a laptop, data on the laptop is changed and the data on the server is 'locked'...
15
by: ingejg | last post by:
I am starting to study internet synchronization, and my head is still spinning since internet is not my forte, however my boss is breathing down my neck at the moment. Our company has only one...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.