January 14, 2010 at 8:47 am
Today I am planning to upgrade a 2 node SQL Server 2005 cluster (running on Windows Server 2003 SP2) to SQL Server 2008.
As far as I can work out I just upgrade the passive node 1st and then failover before upgrading the other node.
BUT:
Has anyone done this before?
Is anyone aware of any potential banana skins?
Should I leave the dbs online whilst upgrading?
Any thoughts or advice would be much appreciated!
Thanks
Richard.
January 14, 2010 at 9:20 am
Test this out first, have full backups handy and also make sure you run upgrade advisor before you do the upgrade.
Thanks...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 3:33 pm
We did something like that and yes it works.
The problem was that we were successful.
Let me strongly advise you before you start to make an exact full copy of the SQL Server directory.
We made the mistake of updating an Exchange server version. The version updates the SQL engine. A Microsoft support call and a lost weekend later....
It is difficult to restore the Master if anything changes on the SQL Server version. So as a pure precaution measure, I would recommend making a full directory backup.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply