Cleaning up Replication Monitor

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Replication » Cleaning up Replication Monitor

22 posts, Page 3 of 3

«««1 2 3

Cleaning up Replication Monitor

Rate Topic

Display Mode

Topic Options

Author

Message

simon.coleman

Posted Friday, July 20, 2012 7:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, July 20, 2012 12:49 PM
Points: 1, Visits: 6

I have had similar problems on a sql2k replication subsystem. Removal of subscriptions from a publication deadlocked+killed, leaving orphaned subscriber info on the distributor.

Replication monitor reports the subscription from distribution database, but publication does not think there are any (until an error is thrown when attempting to delete).
Recreating the subscriber completed ok, but when attempting to delete the new the publication again the new subscription info was removed & an error thrown at the orphaned data again.

To resolve, I went to the distribution database on the distributor & checked for the relevant subscriber in mssubscriptions & found the article data from msarticles
this allowed me to successfully use sp_msdrop_subscription to remove the orphaned data.

After that removal of the publication was ok.

Post #1332940

pnorlin

Posted Friday, November 23, 2012 1:09 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 1:16 AM
Points: 1, Visits: 186

nuwins solution is Perfect, worked perfectly! BigGrin

Post #1388245

« Prev Topic | Next Topic »

22 posts, Page 3 of 3

«««1 2 3

Permissions