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.

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.

  • 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

 

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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