how do i get rid off a db mirror instance

• alen teplitsky

  SSC-Dedicated

  Points: 30014

  More actions

  July 19, 2007 at 2:13 pm

  #174516

  i tested mirroring on a few test servers and got rid of the witness and original server a while ago. still have a mirror instance on one server that i can't seem to get rid of. eating up 80GB of space that i would like to reclaim.

  anyway to get rid of it other than stopping mssql service and manually deleting the files?

• Deepak-405225

  SSCertifiable

  Points: 6120

  More actions

  July 19, 2007 at 10:28 pm

  #720997

  if you want to remove your mirror db you need to remove mirroring first and then only drop the mirror db........

  alter database dbname set partner off

  will turn off the mirroring now if you drop the db you can do it.......

  [font="Verdana"]- Deepak[/font]