AlwaysON Availability Group - SQL Server 2022 - All under an hour

AlwaysON Availability Group - SQL Server 2022 - All under an hour

Anil Mahadev Anil Mahadev

Anil Mahadev

Oracle ACE PRO ? |Principal Cloud Architect (Oracle) @ IDERA Software | Database and Cloud Family of Tools | Multi-Cloud Architect - OCI | *All Views Are My Own and Do Not Represent My Employer*

发布日期: 2023年4月24日
+ 关注

Well Folks!

As mentioned! In under an hour, I was able to successfully, setup an AlwaysOn SQL Server 2022 Availability Group!

I basically followed a bunch of tutorials and was able to finally accomplish this after weeks of planning.

No alt text provided for this image
Primary Node
No alt text provided for this image
Primary Dashboard Node
No alt text provided for this image
Manual Failover
No alt text provided for this image
Querying the Database from the Secondary Node , Now in Primary Status
No alt text provided for this image
Performing Failover back to the SQLNode1 as Primary


No alt text provided for this image
Finally, back to the Primary Node!!

For more details refer to the Microsoft Learn Documentation:

Availability groups: a high-availability and disaster-recovery solution - SQL Server Always On | Microsoft Learn

Cloud & AI WonderScapes Cloud & AI WonderScapes

Cloud & AI WonderScapes

1,354 位关注者

订阅

要查看或添加评论，请登录

Anil Mahadev的更多文章

社区洞察

其他会员也浏览了