September 20, 2016 at 9:52 am
Going to do a upgrade from sql 2008 standard edition to sql 2008r2 on active/passive physical cluster. WHen finished wanted to upgrade the edition from sql 2008r2 standard to enterprise. Some of the MSDN articles seem to point out that this is not possible (and yes I know 2008r2 is ancient sorry 3rd party app play the cards you are dealt). This server is a BI server with 3rd party tool and has analysis server and reporting server on it. ANyone done an edition upgrade on an active/passive cluster?
September 20, 2016 at 11:44 am
tcronin 95651 (9/20/2016)
Going to do a upgrade from sql 2008 standard edition to sql 2008r2 on active/passive physical cluster. WHen finished wanted to upgrade the edition from sql 2008r2 standard to enterprise. Some of the MSDN articles seem to point out that this is not possible (and yes I know 2008r2 is ancient sorry 3rd party app play the cards you are dealt). This server is a BI server with 3rd party tool and has analysis server and reporting server on it. ANyone done an edition upgrade on an active/passive cluster?
Yes and it is supported to go the path you want to pursue. Upgrade paths for SQL Server 2008R2 are listed in this doc:
https://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx
Sue
September 20, 2016 at 12:33 pm
thanks the upgrade path has been clear there are a few unclear articles I have seen which seem to question whether or not you can do an in place edition upgrade on a physical active/passive cluster
September 20, 2016 at 12:49 pm
tcronin 95651 (9/20/2016)
thanks the upgrade path has been clear there are a few unclear articles I have seen which seem to question whether or not you can do an in place edition upgrade on a physical active/passive cluster
I had to do several of them years ago since the company wanted to do in place upgrades. Didn't run into any problems, just did the normal upgrade passive node, failover, upgrade the other now passive node, checking the cluster resources and ownership in the process, etc.
There may be SP requirements, can't remember. Possibly the 2008 needs to be SP2 or 3 to upgrade to 2008R2. Hopefully the vendor is allowing you to be current on service packs so it shouldn't be an issue. But it is doable on a active/passive cluster.
Sue
October 20, 2016 at 9:19 am
tcronin 95651 (9/20/2016)
Going to do a upgrade from sql 2008 standard edition to sql 2008r2 on active/passive physical cluster. WHen finished wanted to upgrade the edition from sql 2008r2 standard to enterprise. Some of the MSDN articles seem to point out that this is not possible (and yes I know 2008r2 is ancient sorry 3rd party app play the cards you are dealt). This server is a BI server with 3rd party tool and has analysis server and reporting server on it. ANyone done an edition upgrade on an active/passive cluster?
There's no SP required for 2008 to 2008 R2 upgrade.
From memory you should just be able to run the 2008 R2 Enterprise installer directly and upgrade the instance on each node.
Failing that, the path you mention is valid, note that the upgrade from Std edition to Ent edition is done once only on the node where the cluster group is running
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply