[Webinar] Streamline your web hosting managementRegister Today


SQL Server Express 2005, 2008 2008R2 instances

Posted on 2011-10-15
Medium Priority
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
  • 2
LVL 39

Expert Comment

by:Aaron Tomosky
ID: 36973346
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 39

Accepted Solution

Aaron Tomosky earned 1500 total points
ID: 36973354
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

ID: 37067422
not really what I was hoping to hear

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

607 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