From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Leverage Always On Failover Cluster Instances

Leverage Always On Failover Cluster Instances - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

Leverage Always On Failover Cluster Instances

“

- [Narrator] SQL servers always on failover cluster instances provide a high availability solution at the server level, providing benefits to every database within the instance at once. The terminology can get a little confusing, so let's start at the top. The Windows Server operating system support an installation mode called failover clustering. In this configuration, multiple physical servers get lumped together into a single cluster which, to the wider network, appears as a single machine. Each server in the cluster is called a node, and together, the nodes share responsibilities for managing resources of the cluster. You can do lots of different things with the failover cluster, and one of those things is to install SQL server on it. When SQL server is installed in a Windows server failover cluster, you get a SQL Server failover cluster instance. This can also be referred to as simply an FCI. Installing SQL Server on a failover cluster is slightly different than installing it on…

Contents