SQL Server 2022 introduced a new feature called Contained Availability Groups. It allows the Database Administrators to effectively manage the Server Level objects, such as Logins, SQL Agent jobs, etc. in an HA environment. In today’s article, we will learn about this new feature of SQL Server.
The Challenge of Managing Server Objects in Availability Groups
Always On Availability Groups were first introduced way back in 2012. It was designed to provide a highly available and disaster recovery solution. The problem with normal availability group is that DBA’s must manually replicate the server-level objects, such as logins, sql agent jobs