Thursday, September 5, 2013

How to uninstall an existing instance of SQL Server 2008 R2

Had an issue with a box with multiple SQL instances installed and needed to remove 2 instances.
I tried to use the SQL install msi but it does not include the tool to remove an existing instance.
I stumbled across this link http://msdn.microsoft.com/en-us/library/ms143412(v=sql.105).aspx.

I thought I would capture the steps visually since the description sometimes does explain where in the GUI the "magic" button is.


1.) Start > Control Panel > Uninstall a Program.  Select the Microsoft SQL Server 2008 R2 Package

 
2.) The next window select Remove

3.) Let the setup rules screen run and click ok.


4.) Select the instance you want to remove
 

5.) Select the features to remove.  Take care not to remove the Shared items as these are used by the other instances of SQL Server on the box.

6.) Select Remove and let the process complete.
 


 
7.) Success






No comments:

Post a Comment