How to create Contained Availability Groups part-1and what will happen if we failover

In this video we discussed about what is Contained Availability group and how to create it. In this demo I made use of cluster less and domain less setup so you will get to know how to create the Availability groups on them as well. Of course there will be 2 databases that gets created one is AGNAME_MASTER & the other AGNAME_MSDB. you will get to know the differences between the objects that appears when connecting to server Name & Listener Name. Finally upon Failover you will see the Linked Servers, jobs, alerts and other dependencies at instance level how it gets failed over Automatically.

[@mortezasafaee6981]

Thank you so much this session it was so useful for me❤

[@shoaibsalmani1187]

Thanks for great content

[@vamsychiranjeevi9619]

Glad you enjoy it!

[@m11713]

Great Content Please show migration from on-prem to azure

[@chaitalib4290]

@author @vamsy chiranjeevi - Have you get success setting up contained AG on windows OS 2022/SQL 2022 enviornment? I am having same problem you mentioned. Please let me know how did you resolve it. thank you

[@nizamettinozpolat1256]

Hello Vamsy, have you realized that BUILTIN\Administrators group is added to sysadmin by default on the listener which is a big security issue?

[@vamsychiranjeevi9619]

Those are demo servers so few things are considered as taking for granted. But not on prod systems though as it allows windows Admin to step in.

[@suryateja6324]

Please more videos on always on please anna

[@vamsychiranjeevi9619]

Yes I made a new video ua-cam.com/video/n5J0bQgb0Eg/v-deo.html

[@galrickgak9615]

How can we join your session?

[@vamsychiranjeevi9619]

you can reach me on my WhatsApp [phone]