December 7, 2006 at 1:58 am
Hi all SQL Server experts!
I have created replication on my two servers (production and backup servers). I used wizards to create it and then generated SQL script for deleting and creating replication. For another task I came across the command sp_removedbreplication 'dbname' and I tried to use that for removing replication more easily on the servers. It seemed to not remove everything on the production server and whenever I install replication now, either by using wizards or my generated SQL scripts I get an error icon (red circle with a black X in it) on my Replication Monitor all the way down to Publisher and the publication named with the computer name. Also this icon is on Agents and Log Reader Agents but not on the actual agent.
Something must have happened when using sp_removedbreplication 'dbname' and I can't fix it. The replication works properly but i wish to not have the error icons.
Does anyone know how the error icons can be removed?
Best,
/M
December 7, 2006 at 1:23 pm
I don't think sp_removedbreplication removes subscriptions...
It is top of my head but I think... you need to cleanup some of the tables in msdb like MSdistpublishers..
Did you restart your service after replication cleanup?
MohammedU
Microsoft SQL Server MVP
December 15, 2006 at 11:01 pm
Thank you for your answer
December 16, 2006 at 10:45 am
Is your issue resolved?
MohammedU
Microsoft SQL Server MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply