Changing Logical Drives in Windows - For SQL 2000 Cluster

Hi there,

I am helping perform a SAN move and basically need to "swap" drive letters (from disks on the OLD SAN to disks on the NEW SAN)... with all data having been actively replicated and mirrored, so that when I bring the "NEW" SAN disks online, they will have the same block-level contents as the "OLD" disk.

I need the feedback pretty urgently, I just want to make sure I am stepping through this properly.  I am familiar with this process, but it never hurts to write it out and ask! =)

I'm pretty sure this is a straightforward process, and wanted to get some feedback that my process is correct.

This is a Windows 2003 Server, running a SQL 2000 Cluster.  We are changing SAN's, so I need to bring the "NEW" disks online (using the SAME drive letters as the OLD SAN) and bring the cluster node back online.

Here is what I projected as requirements:

1.  Ensure all jobs and backups have completed on the SQL Databases, verify any DB Locks & clear them, goto to Cluster Admin and stop all SQL related Services, excluding any disk resources.

2.  In Cluster Administrator, take the source drives offline, and then delete the drive entries.

3.  With all disks being presented to BOTH nodes, start by reassigning the drive letters from the OLD disks away from the existing letters.

4.  Using Disk Management, start re-lettering the "NEW" SAN disks to match that of the OLD disks... (keeping in mind that data on the "NEW" disk is already replicated from the existing disk).

5.  Migrate the Quorum Disk (Q:) - ((I would guess it's best to move the quorum to a temporary location, and then to the final "new" disk once I have changed it's drive letter assignment, correct?))

a.  Start Cluster Administrator (CluAdmin.exe).
b.  Right-click the cluster name in the upper-left corner, and then click Properties.
c.  Click the Quorum tab.
d.  In the Quorum resource box, click a different disk resource.
e.  Choose the drive location for the quorum

4.  After re-lettering is complete, in Cluster Administrator, create a new cluster disk resource for the new drives and adjust dependencies for SQL Server.

5.  Bring the Disk Resource group online, to bring the new resources online.  After Disk Resource group has restarted successfully, bring the SQL Admin group online and verify no errors in the Event Logs.

6.  Open Enterprise Manager and verify that the Database is online and that there are no errors / and that all jobs are processing properly.


Does this sound correct?  Anything I should be looking at that I might be missing?

Thanks for the help everyone!!
bdixon105Asked:
Who is Participating?
 
Justin OwensITIL Problem ManagerCommented:
That sounds like a solid plan.  I would offer this word of caution.  Make sure your Windows servers don't sent an "initialize" command to the SAN (which it likes to do from time to time, especially in clustered mode).  That can result in data loss.  Learned that the hard way. :(
0
 
Ryan McCauleyData and Analytics ManagerCommented:
I assume NTFS permissions are part of your current disk replication - make sure they are, because if they're not, the SQL Service can have trouble writing what it needs to.

Sounds like a good plan overall, though - has all the steps I'd think to include. I'm not sure how the cluster nodes will respond if you take the quorum disk offline though, so you always have the option of attaching an additional LUN, assigning it to the quorum group, and then telling the cluster to use the new drive as the quorum drive instead - that way, your Quorum stays online the whole time, and the cluster will just switch to the new drive. That will change your quorum drive letter though - if you'd prefer to keep it the same, just repeat the procedure again with a LUN on the new SAN, setting the new LUN to use the "old" quorum drive letter, and voila.

Good luck!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.