How to uninstall sql server 2005 on cluster

Since this is an active-active cluster, then there are two instances. Every node is the active node of one instance. Do not stop SQL Server service. Do not put offline any service on the Cluster Manager. Hope this helps. If it is active passive then i would say start from Passive node. Ans If you know which node owns the shared disks choose the other one. I mean the one that do not own the shared disks is the best practice.

I did discover that once SP1 has been applied I cannot reapply it. Typically re-applying the service pack is not necessary, but in this case I applied SP1 and then realized the SQL Server management tools needed to be installed on the passive node. I installed the tools on the passive node and then connected to the active node to run SP1. The installation failed with another Visual Studio-related error.

Now I need to see if it is safe to perform a service pack installation directly from a passive node. Thanks, Dave Thanks, Dave jen Master Smack Fu Yak Hacker Posts Posted - : patching the nodes in a sql cluster can be a bit tricky but not really difficult once you get the hang of it here's a simple guide: 1.

Run the SP1 executable package file from the node active node that owns the group containing the virtual server that you plan to upgrade.

This installs the service pack files on all nodes in the failover cluster. You cannot install SP1 on any other nodes passive nodes in the cluster. Keep all nodes of the cluster online during Setup. This ensures that the upgrade is applied to each cluster node.

I did find a MS document that says "Since the management tools may only be installed on the node which initiated the original installation, if the management tools are installed on other nodes, those must be patched separately from the service pack install on the instance itself. Contents Exit focus mode.

Is this page helpful? Please rate your experience Yes No. Any additional feedback? Search for sql in the search box. Select Uninstall. Submit and view feedback for This product This page. View all page feedback. Please rate your experience Yes No. Any additional feedback? Important To update or remove a SQL Server failover cluster, you must be a local administrator with permission to login as a service on all nodes of the Windows Server failover cluster.

Submit and view feedback for This product This page.