Issues with SQL failover cluster on windows 2016 migration

Yishai Neeman 20 Reputation points
2024-03-12T12:52:37.3433333+00:00

Hi,

We are in the process of migrating our windows server 2012 servers to 2019 and we are using failover cluster to maintain our SQL always on.

As we know , it's only possible to get to 2019 through windows 2016 for compatibility reasons and i'm familiar with the in-place upgrade (https://learn.microsoft.com/en-us/windows-server/failover-clustering/upgrade-option-same-hardware) but i have a new 2016 server on new hardware which i want to add to my cluster.

According to this article (https://learn.microsoft.com/en-us/windows-server/failover-clustering/cluster-operating-system-rolling-upgrade) I learn that "When the first Windows Server 2016 node joins the cluster, the cluster enters "Mixed-OS" mode, and the cluster core resources are moved to the Windows Server 2016 node" .

This actually is what causing the issue for me since once I add the first 2016 server to the cluster it transfers control to it while it's not configured yet and this causes my cluster to go offline.

Does someone knows if there is a way to avoid this transition or to mitigate it somehow? I don't like the idea of a guided failure ( that is offline cluster until the new 2016 node is properly configured).

I would appreciate any help you can offer me.

Thanks,

Yishai

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,743 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
495 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Yishai Neeman 20 Reputation points
    2024-03-14T12:31:09.75+00:00

    I ended up editing the cluster IP of the evicted server to the IP of the new server before adding it to the cluster and that minimized the time the cluster is offline

    0 comments No comments