[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Move Cluster Storage to a New SAN

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

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.