Post reply

Disk exchange on two-node MS SQL 2000 active/active cluster

  • May 21, 2004 at 7:14 am

    #161344

    Hi!

    I have two-node cluster on Windows 2000 Adv Server sp4.  There are two instanses of MS SQL 2000 Server sp3, one on each node.  I have one physical disk owened by the first node, that is not used.  I need to transfer it to the second node, name it with the letter this node already has (removing the disk with this letter from the node by renaming it or just by deleting) and place on it SQL Server logs that were located on the disk with this letter.

    This is my plan:

    1. Transfer disk Z: from node SQL1 to node SQL2

    2. Stop sql server and agent services on node SQL2 (or take them offline with cluster administrator)  WHich is better?

    3. Copy log files from disk V: to disk Z: on node SQL2

    4. Delete disk V: (or rename it as lets say P: ) - I plan to remove the mirror with the former V: disk from storage

    5. Rename disk Z: to disk V: on node SQL2

    6. Start sql server and agent services on node SQL2 (or take them online with cluster administrator) 

    Is the plan correct?  Are there any dangers like (suppose) node signs its drives and will not accept another disk because of it or because the disks are a bit different in size?  Anything else?

    Thanks.

  • May 21, 2004 at 11:28 am

    #507332

    I don't think this will work.  The problem is that cluster resources are managed not by name but by DiskID's.  I think there are some articles about renaming resources and replacing disks.

    Sorry, I know there are articles out there for this but I don't have time to find them right now.  Just wanted to make sure you don't make a bad mistake.

    steve

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply