A Windows Failover Cluster uses shared storage typically, this shared storage is on a SAN. When a SQL Server instance is installed on the cluster, system and user databases are required to be on the shared storage. That allows the cluster to move the SQL instance to any server (or node) in the cluster whenever you request, or if one of the nodes is having a problem. There is only one copy of the data, but the network name and SQL Server service for the instance can be made active from any cluster node.
What is SQL Server Failover Clustering? Print
Was this answer helpful?
What is SQL Server? Microsoft SQL Server is a relational database management system developed by Microsoft. It is a... What is a SQL Server Replication? Replication consists of a set of technologies for copying and distributing data and database... What is SQL Server AlwaysOn? SQL Server AlwaysOn is the new comprehensive high availability (HA) and disaster recovery... Why do I need to install a mail client on my SQL Server computer in order to use SQL Mail? SQL Mail is a Mail Application Programming Interface (MAPI) based application that requires the...