Solved

Windows server 2003 and SQL 2005 Upgrade

Posted on 2014-02-18
3
427 Views
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?
0
Comment
Question by:TKGreen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 18

Assisted Solution

by:lludden
lludden earned 250 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.
0
 

Author Comment

by:TKGreen
ID: 39867993
I am trying to upgrade because I am running ePolicy Orchestrator on this server.
0
 
LVL 2

Accepted Solution

by:
dalberson earned 250 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.

2. UNINSTALL SQL2005
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.
0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Dell Latitude E7240 freezes when coming out of sleep 6 516
Utilities to reset local Win 7 passwords 21 155
Permanently disable Server 2012 hiberfil.sys file 3 175
ost file to pst 10 226
Log files are useful in diagnosing and repairing problems.  This is a list of common log files and their standard locations that I've compiled.   While this is not exhaustive, it is a pretty good list that I've found to be useful.  I may update it f…
Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…

738 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