Creating a Windows Server 2008 R2 Failover Cluster
Connecting to the SAN by Using iSCSI Initiator
iSCSI Initiator is a component built into the Windows Server 2008 R2 and Windows 7 operating systems that you can use to connect to an iSCSI LUN by using an iSCSI target.
When preparing two servers that will function as cluster nodes in a SQL Server 2012 failover cluster, you can configure each server to connect to the same iSCSI LUN for the purposes of shared storage.
- Install the Failover Clustering feature by adding feature with Server Manager or using Windows PowerShell command:
- To install a failover cluster instance
a) run advanced cluster preparation on all nodes
b) run advanced cluster completion on the node that has control of the shared storage device
- Multi-subnet failover clusters have nodes on separate TCP/IP subnets. Use the Failover Cluster Manager console or the PowerShell cmdlet (Move-ClusterGroup ) to perform manual failover.
- Move-ClusterGroup SQLCRG SQL-D
In the event of hardware failure: Evict the failed node from the cluster and then join it after it has been repaired before reinstalling SQL Server.