Disable AG after taking single availability DB offline?

Question

Post reply

Disable AG after taking single availability DB offline?

WebTechie

SSChampion

Points: 11405
More actions
April 12, 2022 at 2:01 pm

#4014566

Good morning,
We had one of folks put in a request to have a database taken offline.
This is the only database in an AG. This, of course, made the AG unhealthy. We receive alerts when an AG goes unhealthy.
The plan was to keep the database offline for a week and then decommission the database and remove the AG.
As far as I know, that isn't possible. If you take the single database offline in an AG, you will cause that AG to go unhealthy. I am not aware of a way to disable an AG, but keep the AG.
If an AG has one database in the availability group and you take it offline, then you have to remove the AG. If not, you will have an unhealthy AG and tons of alerts.
Can anyone confirm this or is there a way to disable an AG and not remove it if it becomes unhealthy?
I hope I properly outlined my question.

Thanks.

Things will work out. Get back up, change some parameters and recode.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80325 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Michael L John One Orange Chip Points: 27060 More actions · Answer 2

WebTechie wrote:

Good morning,
We had one of folks put in a request to have a database taken offline.
This is the only database in an AG. This, of course, made the AG unhealthy. We receive alerts when an AG goes unhealthy.
The plan was to keep the database offline for a week and then decommission the database and remove the AG.
As far as I know, that isn't possible. If you take the single database offline in an AG, you will cause that AG to go unhealthy. I am not aware of a way to disable an AG, but keep the AG.
If an AG has one database in the availability group and you take it offline, then you have to remove the AG. If not, you will have an unhealthy AG and tons of alerts.
Can anyone confirm this or is there a way to disable an AG and not remove it if it becomes unhealthy?
I hope I properly outlined my question.
Thanks.

Create a bogus empty database, and add it to the AG to eliminate the errors. Or, turn off the alerts until your work is finished.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/