SQL Server Disaster Recovery in 15 Minutes | Recover Always On When WSFC Quorum Is Lost
In this 15-minute step-by-step walkthrough, I demonstrate how to recover a Microsoft SQL Server Always On Availability Group during a disaster scenario where the Windows Server Failover Cluster (WSFC) has lost quorum or is completely down.
This is a real-world DBA emergency procedure, commonly required after:
Datacenter outage
Host or storage failure
Split-brain scenarios
Quorum loss in WSFC
Forced failover situations
What You Will Learn:
How to force start a WSFC node without quorum
How to temporarily assign node voting to a single surviving node
How to safely bring the cluster online
How to perform a forced manual failover of an Always On Availability Group
When and how to use FORCE_FAILOVER_ALLOW_DATA_LOSS
Best practices and cautions for production environments
Best Practices Before Executing
Confirm no other replica can be brought online
Validate business approval for possible data loss
Document the incident and recovery steps
Re-synchronize replicas after recovery
Reconfigure quorum once the environment is stable
⚠️ Important:
This procedure is intended for disaster recovery only. Forced failover may result in data loss and should be executed only when no other recovery option is available.
PowerShell: Force Start WSFC Without Quorum
Make sure the Cluster Service is DOWN on all other nodes
Update the node name to the surviving/available node
Import-Module FailoverClusters
$node = "AlwaysOnSrv02"
Stop the cluster node (if partially running)
Stop-ClusterNode -Name $node -Force
Start cluster node without quorum
Start-ClusterNode -Name $node -FixQuorum
Assign voting back to the node
(Get-ClusterNode $node).NodeWeight = 1
Verify cluster node status
$nodes = Get-ClusterNode
$nodes | Format-Table NodeName, State, NodeWeight
T-SQL: Forced Manual Failover of Availability Group
ALTER AVAILABILITY GROUP [AccountsAG] FORCE_FAILOVER_ALLOW_DATA_LOSS;
#SQLServer
#MicrosoftSQLServer
#AlwaysOn
#AvailabilityGroups
#WSFC
#WindowsFailoverCluster
#SQLServerDBA
#DisasterRecovery
#SQLServerRecovery
#HighAvailability
#BusinessContinuity
#DatabaseRecovery
#MSSQL
#EnterpriseIT
#ProductionSupport
#CriticalSystems
#DataProtection
#ITInfrastructure
#DatabaseAdministration
#Failover
#Quorum
#SQLTips
#DBALife