December 12, 2022 at 6:27 am
Hi Experts,
We have a 3 Node SQL Server cluster with Always On, the setup is such that the first two nodes are created with traditional windows cluster & SQL server cluster, the third node is added later to the windows cluster and setup always on.
Now I need to upgrade the OS and SQL from Windows Server 2012 R2 Datacenter to Windows Server 2019 & SQL Server 2014 to SQL Server 2019. My plan is as below, please advise whether this is feasible.
Move all databases to third node-->upgrade node 1 to SQL Server 2019, Node 2 to SQL server 2019 failback database from Node 3 to Node 1 --> upgrade Node 3 to SQL Server 2019
Create a 3 Node windows server 2019 cluster and SQL Server 2019 setup with always on(same architecture as previous)-->create a distributed availability group between old cluster(now upgraded) and new cluster --> Move all databases to New cluster (OS 2019 & SQL 2019) --> Remove the old three nodes.
Is this plan feasible? Are you seeing any challenges\roadblocks in this?
Regards
TIA
December 12, 2022 at 6:28 am
This was removed by the editor as SPAM
December 13, 2022 at 10:11 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 16, 2022 at 9:09 am
Anyone experienced on migrating VLDB from 2014 to 2019
December 16, 2022 at 10:40 am
No need to do a DAG, for this.
You can simply add 3 new nodes to your existing cluster, Windows 2019, SQL2019.
Once done add them as replicas, sync all the data, set them as ASYNC, Manual Failover.
When ready, you do the failover to a new replica, set all the 2019 machines to the right SYNC/ASYNC Auto/Manual settings you need and evict the SQL 2014 replicas from the AG. Then evict them from the cluster.
You can then do a cluster functional level upgrade via powershell.
All is good and you don't need to change your connection strings etc
December 16, 2022 at 7:05 pm
@AntGreen - the process you outline isn't supported. That process allows for one version up on the OS and/or SQL Server only - which won't allow for upgrading to SQL Server 2019 or Windows Server 2019.
However - a DAG can and does support migrating to different OS and SQL Server versions.
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
February 23, 2023 at 6:48 pm
Hi VastSQL,
Can you share your experience migrating AG databases? Finally, what steps do you take?
Thank you,
Regards,
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply