SQL 2016 upgrade to SQL 2019

Douglas Tanner 21 Reputation points
2021-11-04T14:27:28.933+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions
0 comments No comments
{count} votes

Accepted answer
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-11-05T02:59:59.577+00:00

    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful