How do I remove an Instance of a SQL Server in SQL Server 2008

Posted on 2014-08-11
Last Modified: 2014-08-15
Hi Experts,
The current SQL Server 2008 I am working with, has many instances of the same SQL SERVER.  For example:
we have:

These instances were created over the years, by a programmer/DBA who is no longer working at this company.
We need to free up some space in our server.  What do I have to do to remove/uninstall some of these instances?
Is it just a matter of manually deleting the files from C:\Program Files\Microsoft SQL Server\ ?

thanks in advance,
Question by:mainrotor
    LVL 10

    Accepted Solution

    Run the SQL Server uninstall from Add Remove Programs. You can select which instance to maintain.

    See the following for visual reference.
    LVL 10

    Assisted Solution

    equally important.. before uninstalling check to see what DBs are attached and where they are stored.  Uninstalling the instance will not delete user DBs.
    LVL 10

    Expert Comment

    Good catch rlistenb.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now