December 31, 2003 at 3:16 am
Two SQL Server Databases that have to be replicated using Merge Replication are at separate remote locations and are connected by a dialup connection. What would happen if the dialup connection gets disconnected while the replication process is going on. Would the databases at the publisher and subscriber land up with inconsistant data? Also, what would happen if a user resotres a database that has been previously replicated? (either at the publisher or subscriber)
December 31, 2003 at 6:04 am
If the dial up connection goes down the active transaction in the replication process should be roll backed. So you shoudn't have any inconsistant problem.
About the restore, that is easy with the merge replication. Because merge replication saves changes in the publication dbs, you don't need to restore also distribution database.
After restoring, you should only need to sincronize again, and the merge process will do the rest, sending what is missing or different at each node.
January 1, 2004 at 11:07 pm
Thanks for the info. I tried it out and it behaved exactly how you have described it. What I understand from this is that, while synchronizing the data, two transactions are effected. One transaction is the set of data changes (inserts/updates/deletes) done at the publisher are applied to the subscriber. If the network goes down while applying these changes at the subscriber, all the changes applied so far get rolled back if the transaction was not completed. Similar is the case for the other transaction for the set of data changes at the subscriber.
Please let me know if what I understand is right.
Also, I need to know more on conflicts and how to resolve them. Is there any link having good information on the same?
January 2, 2004 at 4:55 am
Can u explan the term "active transaction" first and then can you Elaborate on "active transaction in the replication process should be roll backed"
Hare Krishna
Hare Krishna
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply