AlwaysOn High Availability Manually Failover
In my previous blog i have written on AlwaysOn High Availability Automatic Failover (From Server1 to Server2) and now in this blog i will show you AlwaysOn High Availability Manually Failover (Back from Server2 to Server1)
Step1 : After Automatic Failover Server2 is working as Primary Replica and Server1 is Secondary Replica (Synchronous).
Expand Availability Groups at Server2 –> Right click on “AGSample” and click on “Failover”.
Step2 : You have 2 available Replica to make it as Primary Replica.
Here we are going back to Server1 as primary Replica.
You can select any of replica from Server1 and Server3 but Server3 is Asynchronous commit mode and it has possibility of data loss.
Step3 : Provide connection to Server1 to Connect Replica.
Step4 : Check summary and click on “Finish”.
Step6 : Now Backup to Server1 as Primary.
Server1 is now again working as Primary Replica and Server2 is Secondary and server1 has now Automated Failover server Server2.
Thanks & Regards,
Nirav Gajjar