Tag: Contained AGs

Configuration December 4, 2023

Contained Availability Group Creation Access Violations

Contained Availability Groups are the most recent update to the Availability Groups feature, and a great update at that! They are completely new in SQL Server 2022, and like any new feature (or even mature ones) there will be some bugs. Enter in some Access Violations (AVs) that may occur when creating a new contained […]

Read article

HA/DR May 24, 2022

SQL Server 2022 – Contained AGs – Overview

You’ve Asked, It’s Now Here! The largest complaint, by far, for Availability Groups (AG) has been that system databases could not be part of the AG. This is how mirroring worked, and AGs were an evolution of mirroring, solving many of the problems that mirroring had (although mirroring solved many of the problems log shipping […]

Read article