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 think what I have right now is SQL Server Express 2008 with SP1. What I am trying to install is SQL Server Express 2008 with Advanced Services (and then maybe get SP1 separately on my own).

How should I do this so that I don't lose my data already in database? I don't have much going on in Master. Only my own databases.

edit: should I just run SQL Server Express 2008 with Advanced Services installation and things will get sorted out on their own?

share|improve this question

1 Answer 1

up vote 0 down vote accepted

When upgrading MS products you should use always use a version that is equal or higher than the current version. Most of the time the installation program would check the installed version and refuse to install if "downgrading" is not supported, so you could try.

In all situations, the best option for not loosing data is making a full backup before the installation. It sounds obvious, but it's the best option.

In your case since it seems that there isn't a bundled package of Advanced Services SP1, I would uninstall the current version, install advanced services and then upgrade to SP1 (if possible always use the latest SP).

Other option is upgrading to Express 2008 R2, but note that R2 is a different version, so after upgrading you can't restore backups from 2008 R2 into another server that runs "just" 2008 (for some reason SQL Server never provided a method from restoring/importing a backup from a higher version).

share|improve this answer

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.