Catdog02 0 Posted February 12, 2002 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? Share this post Link to post
clutch 1 Posted February 12, 2002 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). Share this post Link to post
Catdog02 0 Posted February 13, 2002 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 Share this post Link to post