:::: MENU ::::

How to uninstall an SQL Server instance out of multiple instances

  • Dec 06 / 2011
  • 0
dbDigger, Hardware and Platform, System Administration, Windows 7

How to uninstall an SQL Server instance out of multiple instances

While writing an article for MSSQLTips.com, i installed SQL Server 2005 Dev Edition and SQL Server 2005 Express Edition on Windows 7. Dev Edition was with default instance name while Express Edition was named as SQLExpress on machine. After completion of article as a clean up process, it was required to uninstall the express edition.

During this process i noticed that for new DBAs uninstalling an instance out of multiple instances may be confusing if not aware of process. In add/remove programs utility, SQL Server instances are embedded in their versions rather than separate entry for each instance. SQL Server 2005 instances are included under Microsoft SQL Server 2005 entry while SQL Server 2008 instances are included under Microsoft SQL Server 2008 entry.

Uninstall SQL Server 2005 Express edition

So here is how i uninstalled express edition and leaving the Dev edition only in SQL Server 2005 family.

  • Click on Microsoft SQL Server 2005 entry
  • On generated frame select SQL Server 2005 express instance to uninstall
  • Make sure to leave the common components unchecked

Uninstall SQL Server 2005 Express edition from Windows

Now click the Next button to continue with uninstall of selected instance of SQL Server 2005.

Consult us to explore the Databases. Contact us