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.

We have some servers with Windows 2003 and SQL Server 2005 and would like to upgrade them to Windows 2008 and SQL2008 because of the new cool features.

How can that be done? Anything in particular to think about?

share|improve this question

2 Answers 2

If you haven't done this kind of thing before I can't possibly reinforce how important it is to perform a full lab of what you intend to do first, don't skip over the testing and verification step before doing it for real or you will more than likely run into very serious problems.

As for the upgrade itself you have two major upgrades here the OS and the Database server, so a number of questions need to be answered.

Does the server do anything other than serve the Databases? If so can you afford a downtime of up to the time it would take to do a fresh install of the OS / Databases? This would give you the best case scenario, as you would have no traces of the old OS / database server on it.

If you go this route you can upgrade the database by performing backups / restores which is covered well on the Internet already.

Once again don't neglect testing in a lab first!

share|improve this answer
2  
You have a lot of reading to do. And the first 3 steps are backup, backup, backup. –  Kara Marfia May 21 '10 at 2:04
1  
..and the 4th is test the restore process... –  SqlACID May 21 '10 at 10:59

There's a definite order to upgrading SQL and Windows on the same machine. Unfortunately my notes are at work and I'm at home. I'll post my notes here tomorrow when I'm back in the office.

share|improve this answer
    
I just checked my notes and the order of upgrade that has worked for me is to upgrade Windows first, then upgrade SQL. Trying to upgrade SQL first and then upgrading Windows failed and left me with a big mess. –  joeqwerty May 21 '10 at 18:00

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.