December 31, 2008 at 8:52 am
How to install sql server sp2 on cluster environment / sql server 2005
December 31, 2008 at 9:12 am
Installing SQL Server 2005 SP2 on a Failover Cluster Instance:
Note the following information before you install SP2 on a failover cluster instance:
Do not stop the cluster service before you run the SP2 Setup program, or while the installation program is running.
Do not end any running processes before you run the SP2 Setup program.
Do not take the SQL Server service off line before you run the SP2 Setup program. The SP2 Setup program will stop and start the SQL Server service.
Run the SP2 Setup program on the primary node of the failover cluster instance.
You must restart all failover cluster nodes after SP2 is finished installing.
HTH,
MJ
December 31, 2008 at 9:14 am
Follow the link for a detailed installation guide...also be advised that it requires a reboot...
http://support.microsoft.com/default.aspx?scid=kb;en-us;328839
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."
December 31, 2008 at 9:25 am
Rolling upgrade is not supported for SP2.
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."
December 31, 2008 at 9:27 am
After installation dont stop yourself by verifying the summary.txt in the location
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix. it should say all success
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply