While being an awesome feature introduced in SQL Server 2012, Availability Groups were always missing the ability to synchronize server-level objects between replicas. This finally changed 10 years later, in SQL Server 2022, with the introduction of “Contained Availability Groups”.
A contained availability group is an AlwaysOn availability group that supports:
- managing metadata objects (users, logins, permissions, SQL Agent jobs etc.) at the availability group level in addition to the instance level.
- specialized contained system databases within the availability group.
This is all well and good, but we need to talk about something important… About what Contained Availability Groups do NOT do.
You may also check out my webinar: Contained Availability Groups in SQL Server 2022