Choose wisely: SQL Server Failover Cluster Instances vs. Basic Availability Groups



  • alt text

    Creating a cost-efficient High Availability (HA) and Disaster Recovery (DR) solution for your mission-critical databases in Microsoft SQL Server 2016 Standard Edition is no problem.

    There are two options: Failover Cluster Instances (FCI) and Basic Availability Groups (BAGs). However, the real problem arises when customers start choosing between implementing FCI or BAGs. Understanding key differences between these two features is crucial for picking up the proper HA DR solution and avoiding unnecessary expenses.

    Read the White Paper by Edwin M Sarmiento, a Microsoft Data Platform MVP and Microsoft Certified Master, to learn about the differences between FCI and BAGs in Microsoft SQL Server 2016 Standard Edition.



  • @oksana Still backups are needed 🙂