Hi Experts
We have SQL server 2012 R2 two node A/P cluster. Due to hardware limitation in the existing servers we planned to migrate existing cluster to new physical servers. Our concerned is how to bring the existing Windows & SQL Server Cluster name to new cluster. To give continuous application connectivity to end user we have think to do following things.
1. Add new two servers to existing cluster as a new nodes
2. Add new nodes to SQL Cluster
3. Remove the old nodes from the cluster
If someone practice this kind of thing please advice on this
Thanks
It will depend on your Windows OS on the existing cluster - you can only go from 2012 to 2016, or 2016 to 2019 - but not from 2012 to 2019 (only one version up). If the goal is to get to 2019 then you would need to add the 2016 node(s) - migrate the cluster to the new nodes, remove SQL from the old nodes and evict them. Then repeat by adding the 2019 nodes.
Once you have the cluster reconfigured - you can then upgrade SQL Server.
With that said, I wouldn't approach it this way - I would create a new cluster with the latest OS and SQL and then migrate. Yes, this does require changing the connection strings, but it is much safer overall. It allows for recovering back to the original system if there are any issues - and there will be issues.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 8, 2021 at 4:35 pm
Hi Jeffrey
Thank you so much for your reply. Yes, we planned to go with the new installation.
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply