Windows server 2003 and SQL 2005 Upgrade

Posted on 2014-02-18
Medium Priority
Last Modified: 2014-02-20
I have an existing Windows server 2003 with SQL server 2005 that I will be upgrading to Windows Server 2008 R2 with SQL Server 2008. I need to know if 1) this is possible and 2) what the best approach would be?

Should I upgrade the SQL first then the Server or vice versa?
Question by:TKGreen
LVL 18

Assisted Solution

lludden earned 750 total points
ID: 39867964
Doesn't matter.   If you are migrating to new hardware, then get everything up and running on the new system, then backup your databases, and restore them on the new system.

If you are doing an in place upgrade, I'd probably do the OS first, but it really shouldn't matter.

Author Comment

ID: 39867993
I am trying to upgrade because I am running ePolicy Orchestrator on this server.

Accepted Solution

dalberson earned 750 total points
ID: 39868021
You sound like you are working with only one physical server and want to upgrade "in-place". If that is your desired plan, my suggestion is as follows.

1. Make a backup of your database and store the backup on an external drive for safe-keeping. You should also do an "export" of the database, since that sends with it the security logins, whereas a normal backup doesn't. Save the exported database on an external drive also.

3. Attempt the upgrade of the operating system (it is possible that 2003 might require upgrading to 2008 (non R2) before going to 2008R2, but you can try it).
4. Once OS is upgraded to 2008R2, then install SQL2008.
5. Then "IMPORT" the database export you created.

6. The actual "backup" is a last resort, but if you have to use it, you will have to recreate all the security login accounts and reset their permissions. That is why the export/import is better, and preferred.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This is a little timesaver I have been using for setting up Microsoft Small Business Server (SBS) in the simplest possible way. It may not be appropriate for every customer. However, when you get a situation where the person who owns the server is i…
This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  The …
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question