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 - SQL Server Tutorial
From the course: Designing Database Solutions for SQL Server 2016
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.