0

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 '15 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 '15 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 '15 at 19:43
  • @kin, it's NULL. – Racer SQL Dec 11 '15 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 '15 at 19:44
2

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 :

ALTER AVAILABILITY GROUP YourAG REMOVE DATABASE DBthatYouWantToRemove;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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