Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

In-Place upgrade from Windows 2003 to Windows 2008

Posted on 2013-01-29
10
Medium Priority
?
2,156 Views
Last Modified: 2013-02-14
Hi,
 
 I have a Virtual machine(on VMWare box) that is running Windows 2003 Std. 32bit OS.
 I need to upgrade the server operating system from 2003 Std.  to 2008 Std. I am currently running Microsoft SQL Server 2000. After OS upgrade, I will need to upgrade current SQL server 2000 to SQL Server 2008.

  (1) Are there any known issues with in-place upgrade from 2003 to 2008 Std.?
  (2) Once Step (1) is finished, I need to upgrade SQL Server to 2008 version.  Are there any known issues with SQL Server Upgrade?

Thanks.
0
Comment
Question by:sglee
[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
  • 4
  • 4
  • 2
10 Comments
 
LVL 17

Expert Comment

by:pjam
ID: 38831585
Hopefully you are going to windows 2008 64-bit, right?
0
 
LVL 123

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 1000 total points
ID: 38831600
You should be okay, it's supported, just not 32bit to 64 bit.

http://technet.microsoft.com/en-us/l...63(WS.10).aspx

check this document

for your SQL 2000 to SQL 2008 upgrade or migration.
0
 

Author Comment

by:sglee
ID: 38831642
"Hopefully you are going to windows 2008 64-bit, right? "  ----> unfortunately the server box is 32bit.
0
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 

Author Comment

by:sglee
ID: 38831660
0
 
LVL 17

Expert Comment

by:pjam
ID: 38831689
He wanted you to click on Check this document.
sorry about the age of the physical.  32-bit is a thing of the past.  IMHO
0
 

Author Comment

by:sglee
ID: 38831767
"Check this document" ----> that link worked fine. Thank you.

Since the current hardware is 32bit, can I just buy 64bit CPU and repalce current 32bit CPU so that I can install 64bit version of Operating System (like Windows 2008 R2) without having to buy a whole new server box with 64bit CPU?
0
 
LVL 123
ID: 38831774
Wrong link, let me get the correct link.

http://technet.microsoft.com/en-us/library/dd979563%28WS.10%29.aspx

what is the server?

Why do you need to upgrade from Windows 2003 (32bit) to Windows 2008 (32bit)?
0
 
LVL 123

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 1000 total points
ID: 38832712
Just confirmed and check this works for you in our labs.....

Windows 2003 Standard In-place Upgrade to Windows 2008 32 bit no issues.

(make sure you select upgrade!)

Win2k3-Win2k8-Upgrade.jpg
Compatibility Report.jpg
Before you Ugrade it will detect any software that's not compatible and list in the Compatibility Report on your desktop!
0
 

Author Comment

by:sglee
ID: 38832754
Thanks for the correct link.
"Why do you need to upgrade from Windows 2003 (32bit) to Windows 2008 (32bit)?" ---> currently W2003Svr box is running MS SQL 2000. I need to install MS SQL 2008, but in order to do that, I need to have Windows 2008 Server OS first ....

Thanks for the screenshots.

What is the easist of trying the upgrade for testing? Here is my thought:
Currently I have VMWare where W2003 is a virtual machine. I like to make a copy of this VM, shutdown production W2003 VM, open duplicate W2003 VM, change "Datastore ISO File" to W2008.ISO, power on and install with upgrade option?

What do you think?
0
 
LVL 123
ID: 38832770
Yes, that's what we have just done and tested just in our lab!

That way no harm to production server!

Go for it!

Use CLONE if you have that option, or use my EE Article....

HOW TO: Clone or Copy a virtual machine in VMware vSphere Hypervisor ESX/ESXi 4.x or ESXi 5.0

TIP: All can be done in complete isolation, just disconnect the network interface card on the virtual nic!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

721 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