Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Cleaning up Replication Monitor Expand / Collapse
Author
Message
Posted Monday, July 12, 2004 3:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 8, 2008 1:42 PM
Points: 6, Visits: 3
I have sucessfully removed an old publication and it subscriptions, but I am still seeing references to it in the Replication Monitor under Publishers, Snapshot Agents, and Distribution Agents. When I try to delete the listing under Publishers I get an error message that states the following:
Error 21776:[SQL-DMO] The name 'Publication1' was not found in the TransPublications collection. If the name is a qualified name, use{} to separate various parts of the name and try again.

When I try to look at the properties of the agents I get the following error message:
Error 14262: The specified @job_id('xxxyyyzzz') does not exist.

So it appears that the old publication and its components are in fact gone (or at least to SQL Server they cannot be found), but these error messages are still there and I cannot remove them. While this is not affecting any functionality, it "looks" like something is wrong when viewed through SQL-EM.

I am using SQL_EM to manage these replication services, but can run procs through Query Analyzer if that will help.

Any help or direction would be greatly appreciated.

-Chris
Post #125951
Posted Monday, July 12, 2004 5:47 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 6:48 PM
Points: 871, Visits: 281
You may have to refersh the JOBS window to reflect the changes.


Kindest Regards,



Post #125960
Posted Tuesday, July 13, 2004 12:21 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, March 4, 2005 5:51 AM
Points: 84, Visits: 1

I'v encountered the same problems with a replication, When the publication was removed it didnt get totally deleted from the publication server. It all happend some time ago so I don't quite know anymore how I solved it, but I do remember that it made a difference how I removed the publication: by unchecking the database in published databases via the tools menu, or by removing the publication in the Replication tree from Enterprise manager

I think it is a glitch in SQL ...






Bas Schouten

CBIS BV
Post #125987
Posted Friday, July 16, 2004 2:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 8, 2008 1:42 PM
Points: 6, Visits: 3
Turns out I was able to clear everything out by disabling replication (luckily it was on the test server ) and then re-enabling it.

I also needed to run sp_MSLoad_replication_status to clear out the error marks in replication monitor. I have also heard that rebooting achieves the same result, bu this was not an option for me.

-Chris
Post #126771
Posted Wednesday, August 4, 2004 2:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 14, 2006 1:40 AM
Points: 3, Visits: 1

I've come across this problem several times and I'm still not sure what causes it. Previously the only solution I had was to disable replication and re-create all the subscriptions (by scripting the replication before deleting it of course).

However the last time this happened I created a new subscription with the same name as the subscription that was causing the problem and SQL Server let me do it! If you then go on to delete the subscription that replication shows is in error and refresh replication, both the new subscription and the old one have gone and replication shows no errors!




Post #130027
Posted Saturday, June 3, 2006 9:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, May 8, 2009 3:48 PM
Points: 39, Visits: 95

What nuwins suggested worked!

I had a nasty red X in replication monitor for a publication that I had long ago deleted.  So I just made a quick publication with the same name (it allowed me to do this!), and then the red X went away.  Then I deleted the publication normally and the problem was solved!

Post #284720
Posted Friday, January 5, 2007 12:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 11, 2007 6:44 AM
Points: 1, Visits: 1
Brilliant, that worked exactly perfectly for me, too. Thanks!
Post #334773
Posted Saturday, January 6, 2007 2:30 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:56 PM
Points: 1,190, Visits: 583

Another solution for this will be cleanup table in MSDB.



MohammedU
Microsoft SQL Server MVP
Post #334871
Posted Monday, February 4, 2008 2:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 11, 2014 2:50 PM
Points: 8, Visits: 56
This worked great nuwins. I didn't have to remove all publications, just create one with the EXACT same name as the one your are trying to delete. Then delete the publication and it will be gone from the replication monitor. You're kind of "tricking" SQL. Thanks for the help.
Post #451358
Posted Thursday, August 7, 2008 7:17 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, October 11, 2009 3:17 PM
Points: 23, Visits: 107
What if your subscription is on a machine that is no longer available?
Post #548792
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse