October 25, 2010 at 6:03 am
I'm facing a situation where i have to replace the hardware on two clustered servers. Now i'm wondering what the easiest way to do this would be...
Is it possible to:
1. Shutdown one server
2. Replace it with the new one, using the same IP, Name etc.
3. Install SQL-Server with "Add new Node"
4. Re-do all steps on the other "old" machine.
Or do i have to install a new cluster on the new servers and then transfer all databases?
October 27, 2010 at 6:19 am
If you really want to keep the same node configs do the following
➡ Remove one of the servers from the SQL Server clustered instance(s) by uninstalling the software.
➡ Evict\remove the node from the Windows cluster
➡ Shutdown the server and remove
➡ Bring up new hardware deploying the OS using the same computername and IP
➡ Add the node back to the Windows cluster
➡ Add the node to the existing clustered SQL server instance(s)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2010 at 11:11 pm
Perry Whittle (10/27/2010)
If you really want to keep the same node configs do the following➡ Remove one of the servers from the SQL Server clustered instance(s) by uninstalling the software.
➡ Evict\remove the node from the Windows cluster
➡ Shutdown the server and remove
➡ Bring up new hardware deploying the OS using the same computername and IP
➡ Add the node back to the Windows cluster
➡ Add the node to the existing clustered SQL server instance(s)
Thanks for the reply.
Yes! So far i now it will work. The question really is, can i do the exakt same thing with the other server? I dont want to risk that one server is some kind of "master" which cannot be replaced or so...
October 28, 2010 at 4:16 am
Jonas L (10/27/2010)I dont want to risk that one server is some kind of "master"
there is no concept of master here, all nodes are equal!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2010 at 4:26 am
Perry Whittle (10/28/2010)
Jonas L (10/27/2010)I dont want to risk that one server is some kind of "master"
there is no concept of master here, all nodes are equal!
Thanks!
November 2, 2010 at 1:27 pm
Is there a good reason why this new hardware has to have the same names? After all the SQL server instance does not use them.
I would add a third server to the cluster provided it was SQL enterprise, install it up to the same level then evict the redundant node to maintain redundancy.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply