SQL Server Express 2005, 2008 2008R2 instances

Posted on 2011-10-15
Last Modified: 2012-05-12
Sorry if this is a dumb question, but I have machines that have all 3 versions installed and I was wondering if this was normal or are you supposed to migrate from one version to the next.  It seems like some applications install their own instance even if another one already exists.  Even if multiple versions are installed, I only seem to see one set of services running.  I don't get it.

Is there a practical guide to managing all these versions and instances without becoming a SQL server expert?  
Question by:JimMcGraw
    LVL 38

    Expert Comment

    by:Aaron Tomosky
    You usually get this situation from visual studio as I will install SQL for you. I would suggest moving all you databases (backup, restore) to the r2 instance and removing the others.
    LVL 38

    Accepted Solution

    Let me clarify: if this is the situation and all the databases are yours, then it's safe to move them. If you have any instances that are product specific, like Acronis, don't touch those unless you really know what your doing.

    Author Closing Comment

    not really what I was hoping to hear

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    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

    13 Experts available now in Live!

    Get 1:1 Help Now