AlwaysOn High Availability Manually Failover

By on June 12th, 2014

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”.

1
Step2 : You have 2 available Replica to make it as Primary Replica.

Here we are going back to Server1 as primary Replica.

2

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.

3
Step4 :  Check summary and click on “Finish”.

4
Step5 : Verify Result.

5
Step6 : Now Backup to Server1 as Primary.

6

 

Server1 is now again working as Primary Replica and Server2 is Secondary and server1 has now Automated Failover server Server2.

 

 

Thanks & Regards,

Nirav Gajjar

Categorized under: AlwaysOn Availability Group, FailOver, SQL Server.
Tagged with: .