Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Need to do an in place upgrade of a Standard 2008 R2 Server to Enterprise 2008 R2 that has SQL Server running on it.

Anyone have any experiences/issues with this process? I've done this process on server without SQL.

I have considered a format/redeploy/restore, so looking for input on just the above technical situation.


share|improve this question
Are you changing the edition of SQL Server as well, or just changing the edition of Windows Server? – darin strait Jan 12 '11 at 16:57
just windows, not sql itself – Malnizzle Jan 13 '11 at 20:40
up vote 1 down vote accepted

You should be fine doing the in-place upgrade. I've done it with no problems. In general, though, I still prefer to do clean installs on any production server in lieu of an in-place upgrade. A Windows upgrade is different than doing an in-place SQL upgrade, though. I will always do a clean install of SQL instead of an upgrade.

That said, you don't mention what version and edition of SQL Server you're running. Have a look at this Technet article for the SQL OS support matrix.

share|improve this answer

Your Answer


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.