November 20, 2009 at 2:11 pm
I need to upgrade my SQL version in order to create partitions in some tables. I only have one database in production (live). I read some articles where they mentioned I can upgrade the version with:
/wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb
I didn’t find any advice regarding a database in production (live). This server is a fail over and I have 2 nodes.
Any advice?
November 20, 2009 at 2:38 pm
MTY-1082557 (11/20/2009)
I read some articles where they mentioned I can upgrade the version with:/wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb
I didn’t find any advice regarding a database in production (live). This server is a fail over and I have 2 nodes.
Any advice?
My piece of advice is not to upgrade the Production box with the option that you have mentioned.
What is your game plan, you need to upgrade to Ent Edition on the same physical server or you have additional system where you can do this.
What is the Max downtime you can have.
The reason I would go with another machine is, when you have any installation issues or post installation issues (which are very common if you have been watching these forums). Your application will be unavailable until the issues are solved.
When compared to that, building a new server and perform a clean install of SQL Ent Edtn is much easier and quicker and reliable (in terms of non installation issues from registry values)
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 20, 2009 at 2:46 pm
I dont have another machine to set up my cluster. I will need to do it in the same server. About the max downtime. It has to be in a weekend late hours.
so, you telling me that a uninstall and install EE will be the best? It was a failover installation
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply