Move Cluster Storage to a New SAN

Applies to:  Windows Server 2003 Enterprise SP2, SQL Server 2005 Enterprise SP3 CU1.

We have 3 Windows 2003 Enterprise clusters running SQL Server 2005 Enterprise Edition SP3 CU1 each cluster. Our managers requested to move the storage of these clusters (shared drives and quorum drives) from a EMC CX to a new EMC CLARiiON CX4. After doing some research and some tests, we created the following procedure:

1. Connect to the cluster using Remote Desktop and stop SQL Server services using SQL Server Configuration Manager.
2. For each drive of your cluster add a new drive from the new SAN.
3. Restart each node
4. Copy all data from the old drives to the new ones. Quorum disks and shared drives.
5. Use clusterrecovery.exe (from Windows Server 2003 Resource Kit) to move each resource group from the old drives to the ones.
6. Restart each node.
7. Connect via Remote Desktop to one node of the cluster, and start SQL Server services using SQL Server Configuration Manager.
8. Verify SQL Server logs, test failover, restart server applications related to this cluster (if needed), verify applications those applications.
9. Remove old drives.
10. Restart each node.
11. Verify SQL Server logs, test failover, restart server applications related to this cluster (if needed), verify applications those applications.
    
    
    
     

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.