Who is Using CAGs?

While talking to a customer a few weeks ago, they mentioned that they used Contained Availability Groups (CAG) everywhere. They also said they were amazing and wondered why everyone wasn't using them in other environments. Of course, I questioned the "everywhere", which turned out to be more of a default for new systems than a standard across all systems. That's likely true of most things since it's rare we get to update/patch/set something across an environment of any size and ensure every system is the same. Still, setting a CAG as a default makes some sense for enterprises. This ensures that in an HA situation I have my logins, jobs, etc. already on a secondary node. That's been one of the challenges of using lightly linked systems that only sync up database level information. Log shipping, Replication, Availability Groups can all work to keep a secondary ready to take over, but they all miss information that is stored in master or msdb. Read the rest of Who is Using CAGs?

You can listen to Who is Using CAGs? online on Radio and Podcast. Open the player on this page to stream the available audio.

Who is Using CAGs? is an episode from voiceofthedba's podcast by Steve Jones.

This episode is 02:36 long.

This episode was published on May 3, 2026.

Yes. Use the heart button on the episode page to add it to your favorite episodes list.

Yes. This page shows related episodes from voiceofthedba's podcast when more episodes are available from the podcast feed.