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 RTM to SP2 there were errors with respect to the location where the binaries were Installed on the passive Node.
Does anyone know what steps I need to take to Un-Install SQL Server 2008R2 from the passive node and then re-install with the right configuration.
Is it safe for me to use the Config.ini file from Node 1 to install SQL on Node 2?
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/
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.