Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2010-03-25 : 21:30:05
|
| Hello All,I’m planning on installing SP2 on a SQL Server 2005 active node cluster. My question is do I need to install the same SP2 on the passive node? Also if I need to uninstall the SP2 on the server, do I need to uninstall it from both active/passive node clusters?Please advice.Thanks. |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-03-25 : 22:49:38
|
| Whether or not you need to run the service pack on the secondary node depends on what was installed. If there are any non-cluster aware components on that node then you will need to run it.I would recommend running it on the second node after the primary node has been upgraded. The service pack will let you know what components on that node need to be updated.SQL Server 2005 SP2 cannot be un-installed. You would have to un-install SQL Server, re-install it - then patch to the previous version. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-03-26 : 22:08:15
|
| Tara - thanks, I knew I forgot something in that post. Meant to add it, but somehow I missed it... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Need help on installing SP2 on an active/passive n
Tara Kizer