Hi everybody,

I'm setting up peer-to-peer replication topology. Now, my two sites are working well, both sites could make changes to the common database and the common database is synchronized between the two sites.

However I have a question which I still not have the answer my self.

In the case, I have 10 tables need to be synchronized and when one site has finished updating 5 tables and still has 5 tables remains to be replicated but the connection between the two sites is broken.

In this case our application doesn't not work properly because of missing data from 5 remaining tables (which was not replicated).

I still not have a complete solution for this case.
Do you have any idea for this case ? Please help me !

Thank you very much.