April 15, 2009 at 2:48 pm
I have a 2 node A/P cluster. I need to evict the passive node and rebuild it. I currently have SQL 2005 SP3 w/Windows 2008 on the active node. Once the OS has been reinstalled and added to the cluster, I will need to reinstall SQL 2005 SP3 on it.
Do I need to uninstall SQL SP3 from the active node prior to reinstalling SQL 2005 on the rebuilt passive node?
April 15, 2009 at 3:10 pm
When doing the same thing we had the active node at sp 2 with some updates applied. I seem to remember that we had to go back down to at leaset sp 2. The bug we encountered was fixed in sp 3, so you would probably be safe leaving it at sp 3 with no CU's applied.
April 15, 2009 at 3:25 pm
Thank you Sam...
Here's what the SP3 install readme has to say about SP3 and rebuilding a node. It doesn't talk about removing SP3 from the active node, but says that SP3 will need to be installed post the engine installation on the newly added node.
Rebuild a SQL Server 2005 SP3 Failover Cluster Node
- If you must rebuild a node in the failover cluster after SP3 has been applied, perform the following steps:
- Rebuild the node in the failover cluster. For more information about rebuilding a node, see "How to: Recover from Failover Cluster Failure in Scenario 1" in SQL Server Books Online.
- Run the original SQL Server 2005 Setup program to restore the node to the failover cluster.
- Run SQL Server 2005 SP3 Setup on the node that you have added.
April 17, 2009 at 1:20 pm
Here are the steps that I followed successfully :smooooth: :Whistling:
- From add remove programs (active node) change the SQL 2005 install and add the newly created node to the list of failover nodes. This will install the engine. I didn't uninstall SP3 on the active node, however it did give me a warning to upgrade to SP3 on the new node.
- Install Client Tools and other services as necessary - in this case SSIS, NS (logon to the new node)
- Install SP3 on new node (logon to the new node)
- Update the XML config file for Integration Services
Reboot as necessary
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply