I just found a database, and I have no Idea what to do. I can't drop, update, or anything.

The database is in this state: enter image description here

How can i turn it off? Because, it's already off !

enter image description here

I tried to restore database ...set online.

  • ALTER DATABASE <<DB NAME>> SET PARTNER OFF This will remove mirroring.
    – Kin Shah
    Dec 11, 2015 at 19:38
  • i've tried it @kin...set witness..., and other commands from books onlinie, nothing is working. it says it's not configured for database mirroring.
    – Racer SQL
    Dec 11, 2015 at 19:40
  • What do you get when you run SELECT mirroring_role FROM sys.database_mirroring WHERE DB_NAME(database_id) = N'your_database_name' ? Is alwaysON configured ?
    – Kin Shah
    Dec 11, 2015 at 19:43
  • @kin, it's NULL.
    – Racer SQL
    Dec 11, 2015 at 19:43
  • 1
    Can you post the error when you try to drop the database ? That will give some clue.
    – Kin Shah
    Dec 11, 2015 at 19:44

1 Answer 1


Your error message is useful to know that the database you are trying to remove is not in mirroring. It is part of Availablity group.

You can use below command to remove the database from Availablity group :


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.