Win2k AD replication question

Hi, can anyone tell help me answer this question: If I were to setup replication between two 2k server machines and specify a database to be replicated from one machine to the other at regular intervals, can the said database be replicated if it is always open? The DB is an old, third party app that currently runs ...

Windows Software 5498 This topic was started by ,


data/avatar/default/avatar18.webp

83 Posts
Location -
Joined 2002-02-07
Hi, can anyone tell help me answer this question:
 
If I were to setup replication between two 2k server machines and specify a database to be replicated from one machine to the other at regular intervals, can the said database be replicated if it is always open? The DB is an old, third party app that currently runs on an NT server box, I don't have any further info about it in particular. The crux of the question - can replication exist between open applications?

Participate on our website and join the conversation

You have already an account on our website? Use the link below to login.
Login
Create a new user account. Registration is free and takes only a few seconds.
Register
This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic


data/avatar/default/avatar19.webp

3857 Posts
Location -
Joined 2000-03-29
While I am not sure what the specific error will be (simple failure to copy the db because it's open, connection drop due to Win2K file locks being present, db corruption, etc), I would have to say that it would not be successful. Is there any way that you can batch run a backup and sync that? Most current db systems (like MS SQL) have many methods of syncronization that can be done in different ways, like nightly backup and sync jobs or transaction-based where it will update the slave database after each successful transaction. Also, are you using master-slave or merge syncronizations? The backup and transfer method would work much better with master-slave than with merge (and may not work at all on many db systems).

data/avatar/default/avatar18.webp

83 Posts
Location -
Joined 2002-02-07
OP
Thanks clutch, I must confess that this isn't my first line of computer work, I'll pass on the advice to the person that's asked me, I think the biggest drawback is going to be that the database application is an old (old old) program, the guy reckons it runs in NT4 olay, so maybe It'll become clearer when we look at it later.
 
Cheers