Oct 20 2016

MsSQL Server 2012 Availability Groups (AG) Force Manual Failover

Category: AdministrationFatih Acar @ 08:15

When you can not access primary side of AG and you can not run failover on second side (disaster side), you can perform force manual failover operation on second side. You have to know that force manual failover operation can cause loss data which is able to last some database operation.

Failover State

When primary side is down, you can see your Availability Groups and database on SQL Server Management Studio at the secondary (disaster side) like below.

sqlserverforcemanualfailover1

Failover Cluster Manager is down. Probably, you can not see any failover cluster on Failover Cluster Manager.

sqlserverforcemanualfailover2

Force Manual Failover

You can use the forced quorum procedure on a WSFC cluster node to override the safety controls that took the cluster offline. This effectively tells the cluster to suspend the quorum voting checks, and lets you bring the WSFC cluster resources and SQL Server back online on any of the nodes in the cluster.

You have to restart your WSFC (Quorum) with below commands.

Open a command prompt and execute below commands.

net.exe stop clussvc
net.exe start clussvc /forcequorum

sqlserverforcemanualfailover3

Close and re-open Failover Cluster Manager. You have to see your failover cluster.

sqlserverforcemanualfailover4

You have to see Availability Groups like below after refresh SQL Server Management Studio.

sqlserverforcemanualfailover5

Now, you can perform failver operations like below.

sqlserverforcemanualfailover6

sqlserverforcemanualfailover7

sqlserverforcemanualfailover8

sqlserverforcemanualfailover9

sqlserverforcemanualfailover10

You have to see your database as syncronized and AG like below after failover completed.

sqlserverforcemanualfailover11

You can find how to install and configure MsSQL Server Availability Group here : https://www.fatihacar.com/blog/sql-server-2012-alwayson-availability-groups-insallation-and-configuration/

4,670 total views, 2 views today

Tags: MsSQL Server, SQL Server Administration, SQL Server Availability Group

facebook comments:

One Response to “MsSQL Server 2012 Availability Groups (AG) Force Manual Failover”

  1. SQL Server 2012 AlwaysOn Availability Groups Insallation and Configuration – 一站 says:

    […] You can find how to force manual failover Availabiliry Group here : https://www.fatihacar.com/blog/mssql-server-2012-availability-groups-ag-force-manual-failover/ […]

Leave a Reply

Time limit is exhausted. Please reload CAPTCHA.