January 6, 2014 at 1:14 am
Good Day All any happy new Year.
I have a server with 5 Publications, and 50+ subscriptions for each publication (Merge) to various sites.
Publisher = SQL2008, Ent Edition 10.0.4000
Subscriber = SQL2008R2, Ent Edition 10.50.2500
I had one subscriber subscription possibly not sync for 7 days on the one merge publication (Retention period) possibly due to the subscription job failing to run.
When Running the job you get an error:
The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload). (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402)
I have Reinitilized the subscription without upload and once the initilization has completed it still gives me the same error.
I have also remove the subscription database completely from the subscriber and initilized from a new snapshot and still get the same error.
I however did not remove the subscription from the Publisher due to a bug i have encountered once where removing a subscription would remove the system store procs used on the publisher causing all other subscriptions being unable to function and creating a pain to fix and restore the Replication system store procs.
So without removing the subscription from the Publisher is there any way to resolve this issue?
Regards
January 6, 2014 at 1:31 am
I just remembered that the subscriber did not expire, its database crashed / got corrupted and i setup subscription from scratch to resolve this issue due to the replication metadata being effected by the crash.
Again i did not remove the subscription from the publisher but setup everything again on the subscriber no problems.
Regards
January 6, 2014 at 4:20 am
I stopped the job mid way forcing it to roll back the bulk insert.
And started the Job again, and it successfully initialized and the error has been resolved.
Dont know if it made any difference. Or if i just had to try it again.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply