Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I installed Visual Studio 2010 and must have glossed over some of the details. As a result, it upgraded my SQL 2005 Express Edition to SQL 2008 and migrated all my databases.

Is it possible to reinstall the 2005 engine without uninstalling 2008? I'm happy to use 2008 tools to manage the 2005 databases.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Yes, you glossed over the part where it installs SQL Express ;)

2005 and 2008 can live happily together next to each other. You can only have one default instance of SQL Server, though, so if your SQL 2005 install held the default instance then it's probably been upgraded by the 2008 install.

You can run the SQL 2005 installer and reinstall SQL 2005. You'll have to restore your databases from backup, though. The database formats are incompatible between 2005 and 2008.

share|improve this answer
    
Actually, I did see that, but it didn't occur to me that it would UPGRADE sql express! Interestingly, I didn't have a default instance as SQL Express 2005 by default installed itself as the named instance SQLEXPRESS. Apparently that's what 2008 wanted. I'm in the middle of installing 2005 as the actual default instance, which is what I really wanted to do when I first installed. Two birds with one stone? Thanks for the confidence to give the install a try. –  roufamatic Mar 7 '10 at 0:29
    
Sweet, it installed without a hitch and is manageable via the 2008 ssms. Now to import some data and redo my connection strings... cheers! –  roufamatic Mar 7 '10 at 0:47

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.