SQL Clustering and Failover

A SQL server failover cluster provides high system availability by configuring multiple server nodes and network connections of the same SQL server. In the event that one node fails, SQL clustering and failover simply and immediately switches to another cluster node and connection. SQL server clustering and failover eliminates the single point of failure because of the multiple network connections and shared data storage. Network connections are available through SAN (Storage Area Network) or NAS (Network Attached Storage).

When planning a K2 implementation for SQL clustering and failover, there are no specific steps required from a K2 perspective. K2 recommends following Microsoft’s article titled Before Installing Failover Clustering when it comes to preparing an environment for SQL clustering and failover.