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
Continue reading “MsSQL Server 2012 Availability Groups (AG) Manual Failover”

3,470 total views, 2 views today

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


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

Continue reading “MsSQL Server 2012 Availability Groups (AG) Force Manual Failover”

4,192 total views, 4 views today

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


Oct 11 2016

SQL Server 2012 AlwaysOn Availability Groups Insallation and Configuration

Category: AdministrationFatih Acar @ 09:00

Always On Availability Group is a new feature in SQL Server Database with 2012 release. Before this feature, we was using database mirroring feature in SQL Server 2005. But, mirroring has some limitations and weaknesses. and mirroring feature will be disabled near future.

AlwaysOn Availability Groups Features

  • Multi or Single Database Failovers
  • Multiple Secondaries
  • Active (Readably) Secondaries
  • Integrated HA Management

sqlserveravailabilitygroup

System Information

OS: Windows 2012 Server
DB: SQL Server 2012
Side 1: TESTDB1
Side 2: TESTDB2
Failover Cluster Name: TESTDB
Availability Group Name: TESTDB_AG
Listener Name: TESTDBVIP
Listener Port: 1433

AlwaysOn Availability Groups Installation Steps
Continue reading “SQL Server 2012 AlwaysOn Availability Groups Insallation and Configuration”

4,489 total views, no views today

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