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.

ClusterRecovery Tool for W2k3 Server  http://www.microsoft.com/download/en/details.aspx?id=10047

source: http://sqlblogcasts.com/blogs/jasonmassie/archive/2008/02/13/migrating-your-sql-cluster-to-a-new-san.aspx

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s