question

DouglasTanner-4383 avatar image
0 Votes"
DouglasTanner-4383 asked AmeliaGu-msft answered

SQL 2016 upgrade to SQL 2019

I'm running a 3 node Windows Failover Cluster. Windows Server 2016 and SQL server 2016. I want to do an in-place upgrade to SQL 2019. I can failover a SQL instance, on node 1, to another node and then patch all 3 passive nodes on node 1.
Is it possible to failover the 2016 SQL instances, on nodes 2 & 3 to node 1, which is now running SQL 2019?

Thanks

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi DouglasTanner-4383,

Is it possible to failover the 2016 SQL instances, on nodes 2 & 3 to node 1, which is now running SQL 2019?

Do you want to upgrade the SQL failover cluster instance in-place from 2016 to 2019? If I misunderstood, please let me know.
If so, you can go to the Failover Cluster Manager, in the right menu, select “Roles” -> right-click on the cluster and select “Move” -> “Select Node”.
146590-01.jpg

Then you can select one of the passive nodes you want to move.

146635-02.jpg


In addition, to upgrade a SQL Server failover cluster instance, please use SQL Server setup to upgrade each node participating in the failover cluster instance, one at a time, starting with the passive nodes.
Please refer to Upgrade a failover cluster instance and this similar thread which might be helpful.
Best Regards,
Amelia


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



01.jpg (67.7 KiB)
02.jpg (25.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.