October 5, 2005 at 2:27 pm
We have plans to move our current W2000 2 node SQL Cluster with SAN to a blade environment and have also purchased new disk. We will be installing W2003 on the new servers and will cluster 2 SQL nodes. We would like to keep the same SQL instance names and virtual names. Is there a migration sequence that would allow us to reuse these identical names on the new set-up? Also, is there a documented procedure we could reference on moving clustered SQL completely from one server to another. Just want to make sure we are not overlooking any steps in the migration. Also interested in info on moving clustered analysis services and cubes to the new servers/SAN.
October 6, 2005 at 6:56 am
Hello Marilyn,
This is not exactly what you want but there is an interesting article in the september/october issue of SQL Server central magazine about a cluster migration from Win2000 to Win2003 written by Brian Kelly. The article's title is : CLustering the DTC in 2003.
Hope it will help you.
Regars,
Carl
October 6, 2005 at 7:03 am
October 6, 2005 at 7:08 am
October 7, 2005 at 2:24 pm
The easy way is to build the new cluster along side the existing cluster (with totally new names of course). Then after things have been switched (short for moving all the databases/users/etc to the new cluster) you simple update DNS adding aliases. We've done this twice already this year without a hiccup !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply