Delete SQL replikation
Posted on 2013-12-09
My server "SVR1" runs a SQL Server with a transactional publication. On the second server "SVR2" I had a subscription.
Now the SVR2 does not exist anymore and I want to delete the replication on SVR1. (in the SQL Management Studio, the subscription is still visible)
But if I want to delete the SVR2-subscription on the SVR1, I get the error message 20032 "Could not delete the subscription at Subscriber 'SVR2' in database 'ICSDB'."
It can not connect to the SVR2 anymore and this gives the problem of deleting this subscription.
I also tryed:
exec sp_dropsubscription @publication = N'ICSDB_Publication', @article = N'all', @subscriber = N'all', @destination_db = N'ICSDB'
-> it gives me the same error message.
How can I dlete this subscription (and afterwards also the publication)
Thanks for your help
I'm using SQL Server 2008 R2 on Windows Server 2008R2