January 8, 2012 at 8:17 pm
Hi Everyone,
Can anyone help me out in know what is the procedure followed to upgrade 3 - node
sql server 2005 cluster to sql server 2008 on windows server 2008.
Do i need to start the upgrade from passive node or active node?
Can anyone help me in what steps to be followed for upgrading a 3-node cluster.
Thanks in advance.
January 9, 2012 at 4:45 am
I would always want to tackle this by building a new cluster on new hardware. This allows me to separate the build and test of the new system from production workload variations, and guarantees I will not impact production if there is a failure in the build or test process.
If your existing hardware is more than 3 years old it is at end of its service life, so you have a easy reason to justify the expenditure. Otherwise you have to justify the risk of things going wrong when you upgrade in place compared to the lower risk of building and testing before you commit your new cluster to production.
Seriously - if pushed I might consider an upgrade in place on a sandbox environment that can be scrapped if the upgrade fails, but on anything that has a business dependency then the risks more than outweigh any cost savings for an upgrade in place.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 9, 2012 at 5:25 am
Oracle_91 (1/8/2012)
Hi Everyone,Can anyone help me out in know what is the procedure followed to upgrade 3 - node
sql server 2005 cluster to sql server 2008 on windows server 2008.
Do i need to start the upgrade from passive node or active node?
Can anyone help me in what steps to be followed for upgrading a 3-node cluster.
Thanks in advance.
I have to echo Eds comments, i would always prefer a clean install and subsequent migration.
However, if you really want to perform the upgrade you do so by first upgrading the passsive node(s).
Once this is done you failover from the active node to an upgraded passive node. When this happens the instance is upgraded automatically to SQL Server 2008. This is a one way street and there's no going back. Do not carry out the failover action until you ready to render the active node as passive and perform its upgrade.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 9, 2012 at 3:01 pm
Thank you for all suggestions
January 9, 2012 at 3:47 pm
This is not a suggestion, this how you carry out the upgrade 😀
Perry Whittle (1/9/2012)
However, if you really want to perform the upgrade you do so by first upgrading the passsive node(s).Once this is done you failover from the active node to an upgraded passive node. When this happens the instance is upgraded automatically to SQL Server 2008. This is a one way street and there's no going back. Do not carry out the failover action until you ready to render the active node as passive and perform its upgrade.
-----------------------------------------------------------------------------------------------------------
"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