June 29, 2010 at 11:18 pm
Hi,
I'm performing in-place upgrade from SQL Server 2005 to SQL Server 2008 on a/p cluster setup.
I have upgraded the passive node to SQL Server 2008 successfully.
Question:
Now can I apply SP1 on passive node before performing the in-place upgrade on active node? or
upgrade the active node to sql server 2008 and then apply SP1 to passive node & then SP1 to active node?
how this sequence should be?
thanks
June 30, 2010 at 2:58 am
You should upgrade the active node now to SQL Server 2008 before installing the SP1. Then you should run the SP1 on the active node itself after a reboot. Once it is complete on active node, it should have automatically installed the SP1 on passive node also because it copies the binaries on passive node also using the task scheduler services. In case it has not installed SP1 on passive node then you need to fail over it to the passive node & install the SP1 there also.
hope this helps 🙂
-Sujeet
June 30, 2010 at 8:38 am
I did the Inplace ugrade from SQL 2005 to SQL 2008 recently. SQL2008 cluster setup does not install the binaries on another node automatically. You will have to install it seperately on all the nodes. Both the SQL 2008 installation and SP1.
June 30, 2010 at 8:44 am
Mani,
I am planning to do a in place upgrade from SQL Server 2005 to SQL Server 2008 in a active/passive cluster environment. Its one our critical server. How did your upgrade went. Can you share your experiences and docs if you have followed any.
Regards
Hema.,
Regards
Hema.,
June 30, 2010 at 8:52 am
Hema,
If it is windows 2003 server, then the Inplace upgrade is pretty straight forward. The only thing is you will have to install SQL 2008 upgarde on both the nodes seperately and also the Service packs.
June 30, 2010 at 10:41 am
Mani,
I am planning to do a in place upgrade from SQL Server 2005 to SQL Server 2008 in a active/passive cluster environment. Its one our critical server. How did your upgrade went. Can you share your experiences and docs if you have followed any
First, I spend one week to read the complete upgrade document SQL2008UpgradeTechnicalReferenceGuide.docx
Download the above UpgradeTechnicalReferenceGuide from the below link
and then read the upgrade process in BOL http://msdn.microsoft.com/en-us/library/ms191295.aspx
Then tested the below steps couple of times and each time learned new things by posting different questions & issues on SSC forums and gathered the material and documented the solution for the issues I got and repeated the upgrade process as much as I can.
Steps Performed:
1.
Installed Microsoft SQL Server 2008 Upgrade Advisor on a development server and run the upgrade adviser by selecting the Production instance (I did NOT install Upgrade adviser on Production nodes). Download it from the below link
2.
I got couple of procedures which needs minor change after the upgrade and I documented them
3.
Downloaded the Prerequisites .NET Framework 3.5 SP1 & Windows Installer 4.5 and copied them to passive node and active node. I already copied the SQL Server 2008 software & SP1 on to both nodes
4.
Download links for i the .NET Framework 3.5 SP1 and Microsoft Windows Installer 4.5 are as below
.NET Framework 3.5 SP1
http://msdn.microsoft.com/en-us/netframework/cc378097.aspx
Microsoft Windows Installer 4.5
5.
Log on to passive node and installed .NET Framework 3.5 SP1 & Microsoft Windows Installer 4.5. Reboot the node if requires. I remember that I did the reboot
6.
Log on to active node and installed .NET Framework 3.5 SP1 & Microsoft Windows Installer 4.5. Reboot the node if requires. I remember that I did the reboot
7.
Log on to passive node and invoke the SQL Server 2008 setup.exe and followed the setup wizard and completed the upgrade on passive node.
8.
Log on to active node and invoke the SQL Server 2008 setup.exe and followed the setup wizard and completed the upgrade on active node. At this step, while the upgrade is process, the SQL Server resources will be moved to the already upgraded passive node and this will be taken care by setup & we do not need to anything.
9.
Log on to passive node and moved the resources to active node.
10.
Applied SQL Server 2008 SP1 on passive node
11.
Log on to active node and moved the resources to passive node
12.
Applied SQL Server 2008 SP1 on active node
13.
Moved the resources to active node.
Performed the below post-upgrade steps:
1. Change the Compatibility mode to 100
2. Run DBCC UPDATEUSAGE
3. Run DBCC CHECKDB(DBNAME) WITH DATA_PURITY
4. Run DBCC CHECKDB(DBNAME) WITH NO_INFOMSGS
5. Run SP_UPDATESTATS for all the database
6. Backup all the databases
Thanks
June 30, 2010 at 12:10 pm
Thanks for information. Perfect.
Regards
Hema.,
Regards
Hema.,
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply