PC Review


Reply
Thread Tools Rate Thread

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

 
 
Roust_m
Guest
Posts: n/a
 
      21st May 2004
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can a a 2 node cluster support both active/active and active/passive configurations John H Microsoft Windows 2000 Advanced Server 0 19th Sep 2005 02:16 PM
Cluster Service - developer's question: What node is active? J. Patrick Brandt Microsoft Windows 2000 Advanced Server 1 5th Nov 2004 10:32 PM
cluster does not failover when unpluging the public network cable on the active node Sas Microsoft Windows 2000 Advanced Server 0 7th Jun 2004 03:06 PM
Disk exchange on two-node MS SQL 2000 active/active cluster Roust_m Microsoft Windows 2000 Advanced Server 0 21st May 2004 03:13 PM
Disk exchange on two-node MS SQL 2000 active/active cluster Roust_m Microsoft Windows 2000 Advanced Server 0 21st May 2004 03:02 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:55 PM.