SQL Server Performance Forum – Threads Archive

Moving cluster to new shared disk array

Howdy all- This weekend I’m going to be installing and migrating to a new shared disk array for our W2k SQL2k active passive cluster, and I’m wondering if there are any gotcha’s that I should be aware of… We’re going from a U160 enclosure to a 4gbps FC enclosure. The old array had four arrays on it, quorum (E<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />, transaction logs (F<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />, data1 (G: master,temp,model,msdb), data2 (H: several large application databases). The new array will have the same basic layout, but only one data drive on it (G<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />. My plan: 1) shutdown passive node, install FC card 2) reboot, configure FC card 3) connect passive node to FC array, partition and format drives 4) move cluster to passive node 5) add FC array partitions to sql server cluster resources (will not have correct drive names, but to prevent other node from screwing with drives) 6) shutdown former active node, install configure FC card 7) once both nodes are back up and recognize FC partitions as valid cluster resources, detach databases on the H: drive and shutdown sql server <img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> copy logs, data, quorom files, etc from old array to new array. 9) using the windows disk management snapin, move old array drives off drive letters E:,F:,G:, move new array drives to those drive letters. 10) add new array drives as resources to cluster, adjust dependancies for SQL server, and start sql server 11) ? 12) profit I’ve done somewhat similar monkeying with adding new disk resources to the cluster, but I’ve never touched the quorum drive, so that is currently my area of concern… How do I migrate that? Would it be simply enough to make sure that the cluster service was shutdown, then copy the quorum drive, adjust the drive letters and start CS back up? Many thanks! Z

]]>