Скачать или смотреть Migrate from AlwaysOn Availability Groups to SQL FCI (failover cluster instance).

Migrate from AlwaysOn Availability Groups to SQL FCI (failover cluster instance).
Prepared demo environment:
Four virtual machines added as WSFC cluster’s nodes.
AG1/AG2 – stand alone SQL server instances, added to AG
FC1/CF2 – two nodes of SQL FCI (SQLFC12)
AG with synchronized database - [BD_AG_T2_FCI]


Demo plan :
1. During configuration, simulating simple database operations.
2. Check environment
a. Test failover running AG
b. Test failover running SQL FCI
3. Enable AG on SQL FCI
4. Add SQL FCI as new replika to existing AG
5. Restore SQL Server Always On AG database [BD_AG_T2_FCI] on the new replica SQL instance
6. Test failover.
a. SQL Server Failover Cluster Instances (FCIs) do not support automatic failover by availability groups, so any availability replica that is hosted by an FCI can only be configured for manual failover.
b. Manual failover is OK, automatic failover is OK only on AG1 - AG2
7. Set SQL FCI (SQLFC12) node as primary replica of AG.
8. Remove DB [BD_AG_T2_FCI] from AG.
9. Failover AG to AG1 or AG2 node.
10. Remove SQL FCI (SQLFC12) from AG.
11. Stop AG role on WSFC.
12. Test failover SQL FCI (FC1-FC2)
13. Make accessible DB [BD_AG_T2_FCI] on primary replica after removing DB from AG.
14. Add DB [BD_AG_T2_FCI] do AG with the state as it was on the time when we remove DB from AG.