Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to uninstall a named instance of SQL Server 2008 Express with other instances present

Status
Not open for further replies.

Eutychus

Programmer
Nov 14, 2007
61
US
This is probably easy for some who have done it, but I have an installed Instance of SQL Server 2008 Express or SQL Server 2008 R2 Express I'll call Instance CCC and need to remove it. I have two other Express instances I'll call Instance AAA and Instance BBB. I want to uninstall Instance CCC without affecting the other two instances or the software that uses them. Instance CCC should have been installed as a SQL Server 2012 Express instance, so I need to remove the 2008 Instance of CCC and reinstall it as 2012. In all cases, I'm talking about SQL Server Express. Full SQL Server is not installed. I am a beginner, so detailed instructions and warnings would be much appreciated. The Instances are all installed on a Windows Server 2008 R2 Standard server.
I have read that I can do this through Control Panel > Programs and Features, but that I can corrupt or mess up the other instances (AAA and BBB) if I don't do it right. I'm uneasy about this, not having done it before, and do not want to affect the users of the AAA and BBB instances or I'll be in hot water!
Can anyone give me instructions? Thank you much!
 
I have done this before, and you should not affect the other instances. In the SQL Server Setup (which does the actual uninstall), you will be presented with an option of which instance(s) you want to remove. If I recall, you will also be presented with a summary screen before you actually hit the final "uninstall" button.

You could also install a pair of instances on a laptop, or some such, and try the uninstall there, just to practice, and get confidence in the process.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top