May 2, 2005 at 10:46 am
Hello, has anuone done this and has a suggestion to do it in a particular way?
Situation: Running On: Win2k3, SQL2k
A) We have two nodes (node1 and node2) on cluster1 - they are attached to SAN1 - each has 3 virtual server instances - Inst1,2 and 3
B) We purchased a third machine and put it in a different physical location (same domain) attached to a different SAN
C) There will be a 4th server to join the new cluster, therefore creating two paris of servers attached to two different SANs creating two clusters Cluster1 and Cluster2
Question?
I need to move everything from Node2 (in step A) to this new node (called Node3 - attached to a seperate SAN). What is the least problematic way? Can I create 3 new virtual server instances (Inst4,5, and 6), transfer the data and then re-name them later back to Inst1, 2 and 3? Or should I create 3 new instances and tell the users to change their ODBC, etc.... Any other suggestions?
Thanks
A.
May 3, 2005 at 5:44 am
In general terms from the sql point of view moving databases about is no different on a cluster to a single server - however - does your new cluster need to have the same virtual server name as your old server ?
If this is the case this is different - we tried cluster re-naming to switch servers in and out of an environment - it doesn't always work quite how you expect ( it also isn't supported by ms ) so I wouldn't advise that route.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply