SQL Server Performance

Moving cluster to new shared disk array

Discussion in 'SQL Server Clustering' started by zmully, Jan 17, 2006.

  1. zmully New Member

    Howdy all-<br />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=':)' />.<br /><br />My plan:<br />1) shutdown passive node, install FC card<br />2) reboot, configure FC card<br />3) connect passive node to FC array, partition and format drives<br />4) move cluster to passive node<br />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)<br />6) shutdown former active node, install configure FC card<br />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 <br /><img src='/community/emoticons/emotion-11.gif' alt='8)' /> copy logs, data, quorom files, etc from old array to new array.<br />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.<br />10) add new array drives as resources to cluster, adjust dependancies for SQL server, and start sql server<br />11) ?<br />12) profit<br /><br />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?<br /><br />Many thanks!<br />Z

Share This Page