How to use exisiting Windows & SQL Cluster name new cluster

  • 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
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Hi Jeffrey

    Thank you so much for your reply. Yes, we planned to go with the new installation.

    Thanks

     

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply