in

SQL Server Blogs

Voices from the UK SQL Server Community

Jason Massie's SQL blog

Migrating your SQL Cluster to a new SAN

There is a nice utility that does a lot of the heavy lifting for you when migrating your cluster to a new SAN. It is ClusterRecovery.exe. It is designed for replacing a failed disk but when you migrate to a new SAN, you have to go through the same steps. It basically moves all of the meta data like dependencies. The utility can be found the Win2k3 resource kit.

The basic steps are:

1. Present storage.

2. Partition\format\letter. Pick any free letter. We will swap letters later. Let's choose h:\.

3. Stop SQL and move data from old SAN to new SAN.

4. Add the h:\ drive to  the SQL cluster group.

5. Run the cluster recovery tool, connect to the cluster. Choose the old and new drive.

image

6. Open disk management, change the original g:\ drive to a different letter.

7. Change the new drive's letter to the letter of the original drive's letter. h:\ to g:\ in our example.

8. Bring the drives and services online.

9. Remove the old drive resource with the "(lost)" suffice.

 

That is about it.

* Cross posted from http://statisticsio.com *

Comments

 

Migrating your SQL Cluster to a new SAN « Hakan Yuksel Blog said:

Pingback from  Migrating your SQL Cluster to a new SAN « Hakan Yuksel Blog

July 8, 2011 1:20 PM

About JasonMassie

Jason is a SQL Server Consultant for the professional services organization of Terremark (Formerly Data Return LLC) where he has worked for the last 8 1/2 years. Jason is an MCITP Database Administrator\Database Developer as well as an MCDBA on 7.0 and 2000. You can read his blog at http://statisticsio.com. He lives in Irving, TX. He enjoys time with his wife and three daughters as well as making electronic music. He can be reached at http://linkedin.com/in/jasonmassie or jmassie@terremark.com
Powered by Community Server (Commercial Edition), by Telligent Systems