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

PradeepK-4049 0 Reputation points
2024-11-08T15:01:51.8033333+00:00

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.

SQL Server | Other
{count} votes

1 answer

Sort by: Most helpful
  1. LiHongMSFT-4306 31,576 Reputation points
    2024-11-11T07:30:53.9566667+00:00

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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.