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.
- 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.
- 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.
- In the Conflict Viewer, select a table that has conflicts from the list, and click View.
- 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.
- To keep the data in Replica 1, click Keep existing data.
- Click Resolve.
- 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 .