deactivated replication but I can''t delete the databse

• markuss21

  Old Hand

  Points: 340

  More actions

  March 8, 2006 at 12:59 am

  #96676

  Hi ! I get to following problem.

  I have deleted the replication of my database customer. And now, I don't know why, I get the message when I want to delete the databse from my server:

  "The database is needed for a replication"

  How can I drop a replication manually ?

   

  Thanks for your help

  Markus

  (sorry for my bad english) 😉

• Steve-3_5_7_9

  SSChampion

  Points: 10832

  More actions

  March 9, 2006 at 5:59 am

  #625635

  Make sure the database is disabled for replication.

  navigate to:

  configure publishing, subscribers, distribution

  select the "publication databases" tab

  "uncheck" the database you want to disable

• Krishna Mohan Kasi

  Mr or Mrs. 500

  Points: 593

  More actions

  March 9, 2006 at 7:26 am

  #625679

  You can as well try

  sp_removedbreplication '<db name>'

   

  this will remove all the entries corresponding to the replication. 

   

  Also make sure you had followed the correct process for removing the database from replication