Skip to content
Home » What is not contained in contained Availability Groups

What is not contained in contained Availability Groups

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.

Click here to read the full post on the official Madeira Data Solutions blog

You may also check out my webinar: Contained Availability Groups in SQL Server 2022

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.