Dropping db from a replicated backup on different server

• MBHblows

  SSCommitted

  Points: 1614

  More actions

  October 22, 2007 at 12:11 pm

  #178690

  I restored a backp from a server that was in replication and now I am unable to drop this Db. What is the best way to resolve this so that the DB can be dropped?

• Dinakar Nethi-176633

  SSCarpal Tunnel

  Points: 4689

  More actions

  October 29, 2007 at 11:44 am

  #746350

  Try sp_removedbreplication to drop any replication related stuff from the db.

  ******************
  Dinakar Nethi
  Life is short. Enjoy it.
  ******************