Lots time we have done installation of sql server instance as well as removed unwanted instance from server. As a DBA some time we have to uninstall sql server cluster instance, actually uninstalling a clustered instance of sql server is any easy task to do. It always recommended to perform any task first on non production cluster (UAT) server.
Follow the steps by step approach to complete the task.
1. Login into passive node of the sql server cluster to uninstall the instance.
2. Run the sql server 2008 R2 installer. In Maintenance section, select “Remove node from a SQL Server Failover cluster”
3. It will remove all support files for that instance, click on OK.
Click on next
In Cluster Configuration Screen, Select instance name from drop down list and click on next.
In Ready to Reomve node screen, it will give you summary of configuration related to instance. click on remove.