How to create Contained Availability Groups part-1and what will happen if we failover
ฝัง
- เผยแพร่เมื่อ 16 ก.ย. 2024
- 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.
Thank you so much this session it was so useful for me❤
Thanks for great content
Glad you enjoy it!
Great Content Please show migration from on-prem to azure
@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
Hello Vamsy, have you realized that BUILTIN\Administrators group is added to sysadmin by default on the listener which is a big security issue?
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.
Please more videos on always on please anna
Yes I made a new video th-cam.com/video/n5J0bQgb0Eg/w-d-xo.html
How can we join your session?
you can reach me on my WhatsApp +91-9739093905