Groups | Blog | Home
all groups > sql server replication > march 2007 >

sql server replication : Replication Clean Up of Failed Server


Adam Patrick Cassidy
3/20/2007 12:00:00 AM
On my distribution server, I have a failed replication (the big red X) for a
server that had hardware failure a couple of weeks ago. We were able to
bring this client up on a separate server and have re-replicated them. Now
I need to get rid of the failed replication however when I try to simply
delete it, it obviously cannot connect to the failed server since it doesn't
exist and therefore will not delete the information from the DISTRIBUTOR.

I would like to avoid manual system table clean up unless someone has the
method that will completely remove this information.

Is there a way to do this correctly?

Thanks,


Adam P. Cassidy

Hilary Cotter
3/20/2007 12:00:00 AM
Did you follow these instructions?

http://support.microsoft.com/kb/324401

Also on your distributor you may have to issue a call to
sp_dropdistpublisher

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

AddThis Social Bookmark Button