Summary

In this chapter, we have looked at two main features for high availability which can be used with SQL Server 2019. As both Always On Availability Groups and Always On Failover Cluster Instances are dependent on the WSFC feature, we went through the initial configuration of the failover cluster. As the failover cluster topic itself is quite complex, we have deployed a simple cluster with basic options. Usually, in large-scale environments, there will be a dedicated team to fully deploy and configure the cluster for the database administrator.

The FCI is an older approach, based on shared storage; it requires more complex cluster configuration. In business continuity planning, you need to consider your options for high availability at the storage and network level, too, since from an SQL Server and cluster perspective, shared storage can become a single point of failure. The deployment of FCI and AGs is different, so you need to plan carefully regarding which option you would...