Upgrade SQL 2008 Cluster to SQL 2012 Cluster

JL Tech Support 21 Reputation points
2020-08-24T19:17:15.42+00:00

We are currently attempting to upgrade SQL 2008 Cluster to SQL 2012 Cluster. 3 node cluster. We were able to upgrade the A and B nodes but unable to upgrade the passive C node. The passive node doesn't have a database.

In order to upgrade the A and B nodes we had to specify the preferred node of the instance to itself. Now we are unable to fail over A to B and vice versa. It looks as though the folder for the instance on the other nodes haven't been upgraded for the other nodes in the cluster.

Any help would be greatly appreciated.

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,676 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
958 questions
0 comments
Accepted answer
  1. CathyJi-MSFT 21,086 Reputation points Microsoft Vendor
    2020-08-25T02:12:31.303+00:00

    Hi JLTechSupport,

    Did you start upgrade SQL FCI from the passive nodes? Please unchecked the preferred owners option.

    We perform a rolling upgrade to upgrade a SQL Server failover cluster instance to a new version. Use SQL Server setup to upgrade each node participating in the failover cluster instance, one at a time, starting with the passive nodes. As you upgrade each node, it is left out of the possible owners of the failover cluster instance.

    Please refer to MS document Upgrade a failover cluster instance to get more details information.

    If the response helped, do "Accept Answer" and upvote it.

    Best regards,
    Cathy

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest