4

Or do you have to upgrade every FCI on the Failover Cluster? The documentation doesn't seem to be clear.

We have a 7 instances on a 3 node cluster. We want to upgrade only one of the instances from SQL Server 2008 to SQL Server 2012. Can we perform an upgrade or do we need to backup the instance as best we can, uninstall that instance, install SQL Server 2012 then add that instance back?

I know you can run SQL Server 2008 and SQL Server 2012 on the same failover cluster...

The installation makes it seem like you can upgrade a single instance, but I'm still apprehensive since we haven't tested and no documentation seems to explicitly state it's possible.

Select Instance

| improve this question | |
  • Sorry, I've never just tried upgrading a single instance in an environment like this. Do you have a test cluster where you can experiment? – Aaron Bertrand♦ Jun 4 '14 at 18:06
  • I wish we did, unfortunately we don't... – Brad Jun 4 '14 at 18:34
  • Touching this at all without testing it first seems incredibly risky... Can you at least set up the scenario using something like VirtualBox? – Jon Seigel Jun 5 '14 at 17:15
  • We are getting a 3 node cluster to test this with shortly, possibly next week. I will make sure I post the results. – Brad Jun 13 '14 at 13:51
1

This is possible and we successfully completed an upgrade of a single failover cluster instance to SQL 2012 on a cluster with multiple SQL 2008 failover cluster instances.

Perform the upgrade of the instance on the two nodes not hosting the instance first (be sure to select the correct instance when asked as in the screenshot), then finally perform the upgrade on the node hosting the instance.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.