Replication Monitor shows old publication

Question

_{Tuesday, April 12, 2011 1:20 PM}

So, I am using Replication monitor, and under one of my publisher nodes, I still see an old publication, which I do not see in SSMS Object explorer.  This publication shows a red 'x', and I can't view the properties.  I've tried using 'sp_droppublication' at the publisher, 'sp_dropsubscription' at the publisher, 'sp_droppullsubscription' at the subscriber, and 'sp_subscription_cleanup' at the subscriber.

Any ideas on how to get rid of this?  It's making the publisher node show a red 'x' also, which is misleading.  Thanks!

Clint

All replies (3)

_{Tuesday, April 12, 2011 3:35 PM ✅Answered}

you can try running sp_removedbreplication <db_name> but only if there is no other publication on that db.

Other than that look at MSpublications at the distrib db and at syspublications at the published db.

-- Yaniv www.sqlserverutilities.com http://blogs.microsoft.co.il/blogs/yaniv_etrogi

---

_{Tuesday, April 12, 2011 6:45 PM ✅Answered | 2 votes}

Beware of using sp_removedbreplication.  This will remove all replication objects from the database in which it is executed but it does not remove objects from the distribution database:

http://msdn.microsoft.com/en-us/library/ms188734.aspx

If sp_removedbreplication won't work for you I recommend creating another publication with the exact name of the previous one you deleted.  Then, remove the newly created publication following instructions here:

http://msdn.microsoft.com/en-us/library/ms152757.aspx

This should cleanup Replication Monitor.

http://www.sqlservercentral.com/Forums/Topic125951-7-1.aspx

Hope this helps.

---

_{Thursday, June 16, 2011 7:32 PM}

I actually did have to create a new one, then delete it.  Also, however, the old SQL snapshot agent had gotten renamed somehow, and needed to be deleted manually.

 

So, is there no SPs to clean up distributor records if they get left behind somehow?  I see ways to delete from the subscriber and publisher, but no distributor.  Are the ones that delete from the publisher supposed to take care of distributor records also?

Clint