July 12, 2004 at 3:21 am
I need to remove replication that has been (partially) set up by someone else.
Not too sure where to start. Any ideas ?
Thanks
Colin
July 12, 2004 at 6:26 am
First you should remove the subscriptions (pull or push) from all your publications.
Then remove the publications and once you don't have any, remove the distributor.
When removing replication, for me it is better to use EM, bacause removing uses a lot of stored procedures and they have to be executed in order.
July 12, 2004 at 7:37 am
I've tried to do this via my local copy of EM, where I've got my SQL Servers registered. However, it just seems to hang and do nothing.
Am I best to do this from EM on the actual servers rather than my own PC ?
Also, is there any detatching/reattaching going on .... i.e. does this have to be done when there is no activity on the box(es).
Thanks again
July 13, 2004 at 9:25 am
The easiest way to remove a bad replication install is to simply run through the replication wizard again to publish and create the publication again whith the same name. But don't push or pull the subscription. After the publication is created. Close the wizard. Go back to the replication drop down menu and choose "Disable Publishing" if no other databases are using replication on this server or choose "Manage Publications" and drop the publication you just created and then uncheck this database from the "Configure Publishing" dropdown menu.
Or the brute force method (Will not cleanup distributor or subscriptions):
exec sp_replicationdboption @dbname = 'Your DB Name', @optname = 'Publish', @value = 'True', @ignore_distributor = 1
exec sp_droppublication @publication = N'ALL', @ignore_distributor = 1
--dropped all
exec sp_replicationdboption @dbname = 'Your DB Name', @optname = 'Publish', @value = 'False', @ignore_distributor = 1
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply