HOW TO SYNC OUT OF SYNC PEER TO PEER TRANSACTIONAL REPLICATED DATABASES

Question

Suppose I have 1 central server and 19 site location servers; currently even though the replication status shows green but out of 100 replicated tables say 60 are out of sync; at one site; due to unavoidable circumstances (in spite of trying level best say due to internet outage for say 2-3 hours or location server is shut down due to say continuous 3-4 days off at single site or power outage due to planned or unplanned reasons; but central site and other 18 sites working). In such a scenario

1) Is there some automated way in SQL Server 2008 that will make data consistent on this 'out of sync' site server with 1 central and other 18 site servers.
2) If such option possible; does this sync activity needs to be done in quite period or along with data entry going on at (1+18=19; site which is out of sync will not be doing entries until in sync) sites.
3) If no automated way; does any script or proven open source software that does this sync reliably with minimum manual intervention.

Thanks in advance.

Answer 1

Hi @DM ,

Please see this link:
https://www.brentozar.com/archive/2011/06/resolving-conflicts-database/
Hope this can give you some help.

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

When the server comes back online, it will automatically process all outstanding transactions. You do not need to do anything.

Replication is highly resilient.