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

DM 501 Reputation points
2021-12-01T18:23:33.937+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,296 questions
{count} votes

Accepted answer
  1. Seeya Xi-MSFT 16,411 Reputation points
    2021-12-02T07:09:19.98+00:00

    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.


1 additional answer

Sort by: Most helpful
  1. Tom Phillips 17,711 Reputation points
    2021-12-01T18:40:12.937+00:00

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

    Replication is highly resilient.

    0 comments No comments