Requirement: 

We have a requirement to migrate our Storage from NetApp to HP as our organization migrating all our storage to HP.  Presently we have NetApp storage .We have Standalone and cluster SQL servers.

The migration of standalone servers is easy but we had the challenge to Migrate SQL server clusters.

We prepared and implemented the below plan to achieve our migration.

Solution: 

Following steps needs to be executed to fulfill this requirement.

Cluster DB server Details:

Os:                  Windows 2008 R2 Enterprise Edition

SQL :               SQL 2008 R2 Enterprise Edition

Before Migration:  

Please note down the server configuration and also take the backup.

S.NO

Activity

1

Note the SQL server configuration and windows details

2

Stop the application

3

Backup the All the databases

4

Backup Jobs , Login, Operators and linked servers

5

Move all the disks and  resources to Node1

Present the new LUNs

Please prepare the new LUNs from new storage with same size as old storage, We have below LUNS in our production environment, hence we have prepared the size LUNS from new storage.

Present the new LUNs:

Next we will add each of the new RDM Disks to our primary cluster node and secondary cluster node, Your SAN admin will take care of this.

Preparing the new RDM’s in Windows:

Note: these steps need to preform only one node 1

S.NO

Activity

1

Open Disk Management and Rescan the server for new disks

2

Right click on the first new drive and select “Online”

3

Right click again on the first new disk and select “Initialize”

4

Now right click in the right area of the first new disk and pick “Create Volume”

5

Complete the new volume wizard and assign a temporary drive letter

6

Repeat Step 2 – 5 for each new drive

 

Add the new drives to the cluster:

S.NO

Activity

1

Open “Failover Cluster Manager”

2

Expand out the cluster you are working on and select the Storage item in the left tree.

3

On the right click Add a Disk

4

Make sure there are check marks beside all of the new drives you wish to add as a cluster disk

5

Click OK

6

Verify that the new disks now appear under Available Storage in the middle column

Now you have added new storage to our cluster, we have both HP and NetApp storage to our cluster; we need to move our data from NetApp to HP.

 

Move the Cluster Quorum Disk:

S.NO

Activity

1

Open the Cluster Manager MMC, expand the cluster.

2

In the left hand pane, click the cluster name at the top of the list.  In the actions pane go to More Options and select Configure Cluster Quorum Settings

3

Follow through the wizard and the only thing you need to change is on the Configure Storage Witness page.  On this page, simply select the check next to the new storage disk.

4

You have now successfully moved your cluster quorum to another drive, but let’s verify it.  Open Windows explorer and view the new drive.  You should now see a folder called Cluster, which verifies the move

5

If you want to reuse the old drive letter (Typically Q:), then right click the old drive under the Available Storage group and select Change Drive Letter.  Now you can right click the old drive and select delete, which will remove it from the Available Storage group in Cluster Manager

6

In order to assign your new drive to the previously used drive letter, simply right click it in Cluster Manager and select Change Drive Letter.

7

After changing the drive letter you now need to restart the cluster service

Move MSDTC Disk:

S.NO

Activity

1

Open the Cluster Manager MMC, expand the cluster, and select storage in the left hand pane.

2

You In Cluster Manager, expand your MSDTC group, right click the MSDTC resource and select Delete.

3

In the actions pane on the right, click Add Resource and under More Resources select Add Distributed Transaction Coordinator.

4

Double click the resource and go to the dependencies tab.  Here you need to make it dependent on both the network name and the new cluster disk you just added.  Click OK and bring the resource online

5

You have now successfully moved your cluster MSDTC to another drive, but let’s verify it.  Open Windows explorer and view the new drive.  You should now see a folder called MSDTC, which verifies the move.

6

The last thing you want to do is some clean up.  Go back into Cluster Manager and select the Storage node in the left hand pane.  Under your MSDTC group, right click the old MSDTC disk and select Remove.  This will remove the old storage drive from the cluster group and put it back into the available storage group.

7

If you want to reuse the old drive letter (Typically M:), then right click the old drive under the Available Storage group and select Change Drive Letter.  Now you can right click the old drive and select delete, which will remove it from the Available Storage group in Cluster Manager

8

In order to assign your new drive to the previously used drive letter, simply right click it in Cluster Manager and select Change Drive Letter.  The old drive letter will now be available, so simply select it.  After changing the drive letter you now need to restart the MSDTC group.

 

Move the SQL Data Disk/Log Disk/Temp DB Disk:

S.NO

Activity

1

Open “Failover Cluster Manager”

2

Expand out the cluster you’re working on and select “SQL Server” under Services and applications

3

Select “Add storage” from the menu on the right

4

Select the new drive from the list, and click OK

5

Take SQL offline

6

Verify that SQL Server and SQL Server Agent are offline

7

Open Windows Explorer and copy the SQL data from the old drive to the new drive

8

Open Windows Explorer and copy the SQL Log from the old drive to the new drive

9

In New Temp DB drive --Create the folder structure as it is in old Temp DB drive

10

Back in Failover Cluster Manger right click on the old disk and select “Change drive letter”

11

Make the old drive a temporary drive letter other than what it currently is, Click OK

12

Next right click the new drive and select change drive letter, set the new drive’s letter to what the old drive was for both Data /Log and Temp

13

Right click on SQL Server and select “Bring this resource online”, do the same for SQL Server Agent

14

Do the failover to Second node and test the failover

15

Verify the all your databases and other components in SQL server

16

Now bring the SQL offline

17

Remove the Old storage drives from SQL dependencies and Windows cluster

18

remove the old storage from server level

19

Bring the SQL online and check

Finally we done with storage migration from NetApp to HP……..J