I had a multi publisher single subscriber replication in my job and now i want remove it. i disabled the subscriber. Now if i disable the publisher and distributor then it gives me a error cannot drop the distribution DB because it is currently in use. this DB can never be dropped since there is at least one publisher at one time that accesses this DB everytime. How should I disable this publication.
Disable each Publisher, removing any publications caused by that Publisher. Leave the Distribution database until you are removing the final Publisher and then it 'should' be removable.
sql
No comments:
Post a Comment