Procedure to Restore a Replica to a More Recent Backup in SQL Server Replication

Question

I'm encountering an error while synchronizing the replication schedule. Here is the error message:

The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could be lost leading to non-convergence. This could be due to the subscriber not synchronizing within the retention period, or because one of the replicas was restored to a backup older than retention period, or because the publisher performed more aggressive cleanup on articles of type download-only and articles with partition_options = 3.

I found a solution on this URL: https://learn.microsoft.com/en-us/sql/relational-databases/replication/mssql-repl-2147199363?view=sql-server-ver16.

However, the resolution listed there is unclear. Could more detailed steps be provided, possibly with screenshots? Any advice would be appreciated.

Answer 1

Hi @PradeepK-4049

Restore the replica to a more recent backup.

Review this doc: Strategies for Backing Up and Restoring Merge Replication

or reinitialize the merge process without uploading data first.This tech doc includes how to reinitialize a subscription in SQL Server by using SQL Server Management Studio, Transact-SQL, or Replication Management Objects (RMO).

Best regards,

Cosmog

---

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".