What is Failover Clustering in SQL Server ?

With failover clustering, the nodes share disks, but only a single node has access to the database at a time. It is possible to install additional SQL Server failover cluster instances across the nodes; however, this configuration cannot be used to re-direct workloads for a single database (for example, separating reads from writes).



You May Interest

How to Restart SQL Server in Single-User Mode ?

What is TABLESAMPLE in SQL Server ?

MS SQL Restoring a Database With a Query

What is the Difference Between DB Mirroring and Log Shipping in S ...

General Information List of All Allowed Databases in MS SQL Serve ...