Cannot drop the database 'distribution'

• luckysql.kinda

  SSCertifiable

  Points: 7816

  More actions

  September 8, 2009 at 5:41 am

  #214735

  Hello Team,

  I had replication setup on my server and now I want to drop this set up.

  I have deleted publisher and subscriber but distribution database is still there. I get following information when I try to drop this database.

  Cannot drop the database 'distribution' because it is being used for replication. Did I miss something to drop the replication?

  -LK

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  September 8, 2009 at 6:20 am

  #1050446

  This may help you http://www.sqlservercentral.com/Forums/Topic781039-291-1.aspx

• luckysql.kinda

  SSCertifiable

  Points: 7816

  More actions

  September 8, 2009 at 7:59 am

  #1050523

  Many thanks. This helped.

  -LK