Solved

windows 2003 standard to windows 2008 enterprise 32bit

Posted on 2010-09-18
10
370 Views
Last Modified: 2012-05-10

I need to upgrade a windows standard 2003 R2 server to Windows 2008  32bit. There are MS SQL 2000 and 2005 running on this server too.
I like to do this upgrade inplace first so I can add extra RAM to speed it up. If it still is slow then I might purchase a new server. Then Definitely I will install 2008 64 bit on that.
I need you advise me how to do inplace upgrade after making a good backup. Do I need to do anything with MS SQL 2000 and 2005? Am I going to have any compatibility problems?
I also need your advise for my last choice going with a new 2008 64bit. Am I going to have difficulties with installing MS SQL 2000 and 2005 on the new server? Considering the 64bit OS?

Thanks
0
Comment
Question by:Jay555
  • 5
  • 4
10 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 180 total points
ID: 33710428
>>  I need to upgrade a windows standard 2003 R2 server to Windows 2008  32bit.. If it still is slow then I might purchase a new server.

If possible try to install Windows 2008 64 bit to have more benefits.

>> I need you advise me how to do inplace upgrade after making a good backup. Do I need to do anything with MS SQL 2000 and 2005? Am I going to have any compatibility problems?

Before upgrading just check with SQL Server 2008 Upgrade Advisor provided below and make sure that you have solved all compatibility issues before performing inplace upgrade. Else its recommended to take backup of user databases, logins, jobs, maintenance plans and restore all those in new installation of SQL Server 2008.
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=F5A6C5E9-4CD9-4E42-A21C-7291E7F0F852&displaylang=en

>> I also need your advise for my last choice going with a new 2008 64bit. Am I going to have difficulties with installing MS SQL 2000 and 2005 on the new server? Considering the 64bit OS?

New 64 bit OS and SQL Server, you can really get good performance. However you can install 32 bit versions of SQL Server on 64 bit OS but do remember you need to enable AWE so that SQL Server can utilize more than 4 GB memory.
0
 

Author Comment

by:Jay555
ID: 33711150

Thank you for a quick response.
I am not going to upgrade to SQL 2008 at all at this time (Ijust want to upgrade the win 2003 R2 standard server to Win 2008). I asked :
1- Am I going to have difficuties with SQLS(2000 and 2005) by doing inplace upgrade from win 2003 R2 standard to Win 2008 32bit? The problem I have now is in middle of the server almost stops working because of very bad performance. It only has 4 GB RAM and the activities on this server (Several SQL databases and some other roles like File server role for 150 users) are beyond the RAM capacity of it.
2- Besides having a full back up, is there anything I should be worried for inplace upgrade?
3- I am also thinking purchase a new server within 2 months, then use it as a Win 2008 64bit. Is there going to be any problems taking the MS SQL (2000 and 2005) and the datbases running under the SQL on that new win 2008 server?
 
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 180 total points
ID: 33711462
I didn't think Windows Server 2008 supports SQL Server 2000. And performing inplace upgrade from 2003 R2 to 2008 would not remove the underlying OS issues. Compared to that, fresh installation would bring more performance..
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:Jay555
ID: 33712213
Thanks again,

I found out that SQL 2000 could be installed on Windows 2008 server. Here is the link for the source:
 http://dbaspot.com/forums/sqlserver-server/393852-sql-server-2000-windows-2008-a.html
I think upgrading from 2003 standard to 2008 allows me to add Extra RAM in order to speed up the process.


0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33712901
It cannot be installed on Windows 2008.
Since SQL Server 2000 mainstream support ended, User says you can install at your own risk and that user has installed 2000 on his Vista machine and not Windows 2008.
Kindly check it out..
0
 

Author Comment

by:Jay555
ID: 33713391
Latest cmment from the link clearly says it is doable

0
 
LVL 5

Assisted Solution

by:JHalliday
JHalliday earned 70 total points
ID: 33714623
A couple of observations

While it is claimed it may be possible to get SQL2000 to run on Windows 2008 it isnt advisable or supported by Microsoft and may result in much slower performance than you would expect due to the services having to run in compatability mode.  Also you may find that some services may fail unexpectedly or not run (such as SQL Agent).

You won't be able to do an in-place upgrade from Win2003 R2 to Win2008 64bit you can only upgrade 32bit to 32bit or 64bit to 64bit.

Finally what is the spec of the server you are installing and what is your reason for the upgrade as all indications are that your current demand on the server has outgrown its capacity.
0
 

Author Comment

by:Jay555
ID: 33715076
Thanks again.
I think i mentioned that the inplace option is with 32bit win 2008.
My main goal is to have enterprise windows on this server. This way i can add extra memory to speed up the server operation
0
 

Author Comment

by:Jay555
ID: 33715077
Thanks again.
I think i mentioned that the inplace option is with 32bit win 2008.
My main goal is to have enterprise windows on this server. This way i can add extra memory to speed up the server operation
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 180 total points
ID: 33717107
>> Latest cmment from the link clearly says it is doable

As per microsoft, SQL Server 2000 is not supported in Windows Server 2008 and you won't get any support if you face any issues later on.

>> I think i mentioned that the inplace option is with 32bit win 2008.

If you want to go with SQL Server 2000 in 32 bit Windows 2008, then you can proceed..
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

773 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