From the course: SQL Server 2016: Administer a Database Infrastructure

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Configure Windows clustering

Configure Windows clustering - SQL Server Tutorial

From the course: SQL Server 2016: Administer a Database Infrastructure

Start my 1-month free trial

Configure Windows clustering

“

- [Instructor] Some of SQL Server's most important features are built on top of other Microsoft technologies. The Windows server operating system supports server clustering, which enables SQL Server to use multiple machines in order to protect against hardware failures. To enable the feature in SQL Server, you first need to have a Windows Failover Cluster. A cluster is a group of physical machines or virtual machines that work together to provide services. Each individual machine is called a node, and each node in the cluster is connected to, and responsible for monitoring the other nodes. If one of the nodes becomes unavailable, or otherwise fails, the remaining nodes will immediately notice and assume the responsibilities previously assigned to the failed node. This process of assuming responsibilities is called a failover. In order for the Windows cluster to be suitable for a SQL Server failover clustering, they need to be configured with a shared storage location called clustered…

Contents