-
Not able to delete Distribution Databse
Hi
Does anyone know how to drop Distribution database set up while replication. I am getting following error message:
Msg 3724, Level 16, State 3, Line 1
Cannot drop the database 'distribution' because it is being used for replication.
I tried many things, but nothing seems to work and even I am not able to find any solution online.
Need help please!!!
-
You should delete all subscriptions and publications before you can delete distribution database.
-
Or remove replication on the server, that will drop distribution db.
-
Thanks for help!! it worked
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|