Results 1 to 4 of 4

Thread: Not able to delete Distribution Databse

  1. #1
    Join Date
    May 2009
    Posts
    41

    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!!!

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You should delete all subscriptions and publications before you can delete distribution database.

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    Or remove replication on the server, that will drop distribution db.

  4. #4
    Join Date
    May 2009
    Posts
    41
    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
  •