March 7, 2012 at 7:36 am
Hi, All
I've tried the sp_removedbreplication 'Subscriber DB', but the publications still in the distribution.dbo.MSpublications table. I've tried sp_removedbreplication 'publisher DB' at publisher also. But the result is publications and subspriptions removed from the GUI replication. The jobs still there and the distribution.dbo.MSpublications data still there.
When I tried sp_dropsubscription at the publisher DB, it will raise 'The publication does not exist'. And dbo.syspublications shows all publications do deleted from publisher DB. But the thing is how can I delete them from subscriber also.
My distributor is same as the subscriber server and there's another publisher server also used this distributor.
Publisher is another server.
Regards
Billy
March 10, 2012 at 3:39 am
Fixed by manually run the below script at distributor server:
update msdb..MSdistpublishers
set active = 0
where name = 'publisher server'
Then run the sp_dropdistpublisher to drop publications successfully at distributor server.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply