February 1, 2008 at 5:57 am
Hello,
Can you help in the following points?
1st: How can i migrate/copy one SQL Server Cluster to new machines and what points should i really take care?
2nd: Is it possible to install the SQL Server Cluster with same name, ip's and after join this cluster to same Domain. I presume that we must stay the actual Cluster online until we have complete sure that th other cluster its ok.
3rd: Should i remove the BUILTIN\administrators group from my SQL Server Cluster? Why should i remove this user?
4th: How can i be sure that users are not connected with admin accountss
Regards,
JMSM
February 1, 2008 at 6:52 am
Why are you moving the Cluster? how did this idea come about?
February 1, 2008 at 7:40 am
we did this twice this year where we moved to new hardware and kept the same names/ip
you have to uninstall the old cluster and only then can you install the sql instances on the new hardware with the same name. if there is a rollback, same process
February 1, 2008 at 7:45 am
Hello,
The idea is to change the cluster to new hardware.
So i need to know how can i do it with less loosing of time and with the most perfection :blush:
The point is that like i told you i'm not feeling comfortable to do it and because i'm working in a new place so i don't know yet the environment very well.
Thanks and regards
JMSM;)
February 1, 2008 at 7:47 am
use the cluster resource utitlity to backup the cluster resource checkpoints prior to moving to the new hardware. That way if you have a problem with the quorum disk you can restore the cluster checkpoints.
February 1, 2008 at 7:57 am
Thanks again,
Can you tell me if Should i remove the BUILTIN\administrators group from my SQL Server Cluster? and Why should i remove this user?
Thanks and regards
JMSM
February 1, 2008 at 8:15 am
There are arguments for and against removing the Builtin\administrators group. The below linked article should help.
February 1, 2008 at 8:27 am
i would also have a new quorum disk set up on the new cluster. the cluster name can be different, you are looking to have the same sql instance names and IP so you don't have to redo your apps. if you are moving to a windows 2003 cluster look in books online to set up MS-DTC. the process is a bit different than windows 2000.
in our case we had the new cluster set up a week prior to the move and uninstalled the sql instances and installed them on the new cluster. old cluster is still up and running with only the cluster resource on it.
reason you have to uninstall the old sql instances is that it creates computer accounts in AD and you won't be able to install the new one since it will do a discover and find the old one.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply