GM008
11 years agoLevel 2
Un Installing SQL Server 2008 R2 from Passive Node
We have an Issue on one of our Veritas Cluster sitting on Windows 2008 (6.0), SQL Server 2008R2 was not Installed properly on the passive node, when they tried to upgrade the SQL Service pack from RT...
- 11 years ago
Hi,
Uninstalling a SQL Server Clustered Instance
http://www.mssqltips.com/sqlservertip/2172/uninstalling-a-sql-server-clustered-instance/
http://www.youtube.com/watch?v=-rUCyxlossk
sql 2008 r2 sp1 upgrade active/passive node
Uninstalling a SQL Server Clustered Instance
http://www.mssqltips.com/sqlservertip/2172/uninstalling-a-sql-server-clustered-instance/
- 11 years ago
Dealing with SQL in the SFW-HA cluster will add a couple extra steps.
You can do the following because your primary node works:- In VCS remove the passive node from the available node list for the SQL service group.
(In VCS...Click the service group on the left -> Click Tools at the top -> "System Manager...") - Uninstall and reinstall SQL, you can install locally on the passive node.
(Keep the same Instance name) - Run the SFW-HA SQL wizard to add the passive node back to the service group
Notes on step 3:
- Run the SFW-HA SQL configuration wizard from the active primary node only (This is critical)
- The SFW-HA SQL wizard uses the paths from the node where the wizard is run
- This will change the local paths, on the passive node, to point back to the shared storage
- This will also get the passive node’s instance back under the context of the virtual server name
If you run into any problems please feel free to open a support case with us. We are here to help.
- In VCS remove the passive node from the available node list for the SQL service group.