Oct 21 2016

MsSQL Server 2012 Availability Groups (AG) Manual Failover

Category: AdministrationFatih Acar @ 09:57

If primary side of Availability Groups (AG) is down and can not be online, you can perform failover operation. When primary side is down, probably, you can see state of Availability Groups at the secondary side like below.

sqlserverfailoversteps1

Failover Steps

sqlserverfailoversteps2

sqlserverfailoversteps3

If you get an error after click Failover button, probably your AG has a problem. You can use force manual failover steps. Steps is here : https://www.fatihacar.com/blog/mssql-server-2012-availability-groups-ag-force-manual-failover/

sqlserverfailoversteps4

sqlserverfailoversteps5

sqlserverfailoversteps6

sqlserverfailoversteps7

sqlserverfailoversteps8
You can see your database status like below after failover operations.
sqlserverfailoversteps9

SQL Server 2012 Availability Group install and configure steps are here : https://www.fatihacar.com/blog/sql-server-2012-alwayson-availability-groups-insallation-and-configuration/

3,846 total views, 4 views today

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

facebook comments:

Leave a Reply

Time limit is exhausted. Please reload CAPTCHA.