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:
How can i turn it off? Because, it's already off !
I tried to restore database ...set online
.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityYour 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;
ALTER DATABASE <<DB NAME>> SET PARTNER OFF
This will remove mirroring.set witness...
, and other commands from books onlinie, nothing is working. it says it's not configured for database mirroring.SELECT mirroring_role FROM sys.database_mirroring WHERE DB_NAME(database_id) = N'your_database_name'
? Is alwaysON configured ?NULL
.