Can you direct Availability Groups to fail over to a specific node in the cluster?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Windows Server Failover Clustering (WSFC) with SQL Server does have the option to failover to a particular node and Availability Groups seem to build on WSFC.
Taken form the MSDN:
For alwayson availability groups, you can't do that. After a failover SQL server will revert these settings to the current primary node. So it won't work.