Resolve synchronization conflicts between replica set members

Microsoft Replication Manager

Resolve synchronization conflicts between replica set members

Conflicts can occur if data has changed in the same record of two replica set members that have been synchronized.

  1. Start the Microsoft Replication Conflict Viewer by using one of the following steps:
    • Open the database that you want to check for conflicts. If there are conflicts, you are asked whether you want to resolve them. Click Yes to proceed.

    • On the Tools menu, point to Replication, and then click Resolve Conflicts.
  2. In the Conflict Viewer, select a table that has conflicts from the list, and click View.

  3. For each conflict shown in the Conflict Viewer, choose one of the following options.
    • To keep the data in Replica 1, click Keep existing data.

    • To modify the data in Replica 1 and copy it to Replica 2 on the next synchronization, click Keep revised data.

    • To keep the data in Replica 2 and overwrite the data in Replica 1 on the next synchronization, click Overwrite with conflicting data.

    • To modify the data in Replica 2 and overwrite the data in Replica 1 on the next synchronization, click Overwrite with revised data.
  4. Click Resolve.

  5. Repeat steps 3 and 4 as many times as necessary to resolve each conflict in the table.

Notes

  • The record of conflicts can be lost if you delete or move a replica. Before deleting or moving a replica, check it for conflicts.

  • For more information about synchronization conflicts, click .