Replication monitor shows duplicate merge subscription
in [Replication]
|
Prev: Transactional replication fails with connection refused error
Next: Unexpected eof encountered in bcp data file...msmerge_genhistory90.bcp
From: persillade on 19 Sep 2008 10:55 I had a merge replication subscriber where I had to recreate a push subscription but it wouldn't create, saying the subscription already existed. I ran sp_dropmergesubscription on the publisher and then ran sp_helpmergesubscription and verified there was no record for that subscriber in the output. I recreated the subscription and now (although it is synchronizing), replication monitor shows duplicate entries for that subscriber. Running 'select * from msmerge_subscriptions on the distributor' or sp_helpmergesubscription only shows 1 entry. Has anyone seen this and know how to fix it?
From: Paul Ibison on 2 Oct 2008 11:49
What happens if you force a refresh of the monitor: exec dbo.sp_replmonitorrefreshjob HTH, Paul Ibison (www.replicationanswers.com) |