1

Answer in the following thread says: activate Service Broker on a database in an Availability Group

"You need to set RegisterAllProvidersIP to 0 Thereafter take the availability group offline and bring online again."

Is it easy to bring an AG online after taking it offline. Documentation says: After an availability group goes offline, its databases become unavailable to clients and you cannot bring the availability group back online. Therefore, take an availability group offline only to migrate the availability group resources from one WSFC cluster to another.

1 Answer 1

0

Is it easy to bring an AG online after taking it offline.

That entirely depends on why the AG went offline. Taking an AG offline manually should pretty much never be an action that is done. There are reasons to, however those are generally after other bad things have happened and you're attempting to remedy the situation (whether those issues were internal to SQL or external).

Documentation says: After an availability group goes offline, its databases become unavailable to clients and you cannot bring the availability group back online. Therefore, take an availability group offline only to migrate the availability group resources from one WSFC cluster to another.

That's correct, there is a cross cluster migration but no one should ever do it. This is a hold over from a very long time ago (10+ years at this point) when there wasn't a good solution for upgrading an AG across clusters. Now every version of SQL Server in mainstream support has the ability to migration across clusters natively via distributed AGs.

"You need to set RegisterAllProvidersIP to 0 Thereafter take the availability group offline and bring online again."

Hard to respond to this because in a vacuum it's arguably misleading but with a specific use case it can be arguably mostly correct. The thing about "take the AG offline and bring it online" seems to be the major hold up here. In this above specific scenario, just do a failover as that will take the AG offline and bring it online on another node. I'm not sure why the hang up or wanting to bring an AG offline, randomly, and leave it that way.

So going back to is it easy to bring it online, then yes do a failover and it'll take it offline and bring it online. That's kind of trivial. Taking an AG offline and just leaving it that way I don't see many use cases for this.

4
  • Does it mean that answer in dba.stackexchange.com/questions/278528/… is wrong?
    – Warer
    Commented Mar 5, 2023 at 16:48
  • Yes, it's completely incorrect. That's most likely why a moderator deleted the answer. Commented Mar 5, 2023 at 18:23
  • Sorry for not being clear Sean. In the answer the person says, "Thereafter take the availability group offline and bring online again.". How can we do it, when "Taking an AG offline manually should pretty much never be an action that is done"
    – Warer
    Commented Mar 5, 2023 at 23:42
  • How and why are two different questions. Why are you wanting to do this, what problem are you trying to solve? Commented Mar 6, 2023 at 0:40

Your Answer

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

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