Microsoft SQL Server Failover Cluster Instance and Basic Availability Group features comparison
Posted by Dima Yaprincev on November 9, 2017


Microsoft SQL Server 2016 has a pretty decent feature set to achieve cost-effective high availability for your environment and build a reliable disaster recovery solution. Basic Availability Groups (BAGs) and Failover Cluster Instances (FCI) are included in SQL Server 2016 Standard Edition and serve to implement high redundancy level for business-critical databases. In this article, I would like to discuss some differences between these solutions and open the curtain on how it can be done with Software-Defined Storage like Storage Spaces Direct (S2D) and StarWind Virtual SAN (StarWind VSAN).

Failover Cluster Instance versus Basic Availability Group image


Appreciate how useful this article was to you?
No Ratings Yet