SQL 2000 Enterprise on Server 2008

[paul1979]

We're looking at upgrading our aging SQL box for something with a bit more power and memory in it.

If I understand correctly, to get access to more than 4Gb of RAM, I need a Windows installation that will also access the extra, so I'm looking at Server 2008 (x64).

However, the additional cost in migrating to SQL 2005 or 2008 looks prohibitive (at least to my management...!), so can I run our existing SQL 2000 Enterprise (32bit AFAIK) on the proposed new box, and get access to the more RAM?

All donations of better ideas gratefully accepted

 

[JayKusch]

If this is a Production server with any worth to it, you are really walking a fine line by trying to go this route.

Being SQL 2000 is not longer supported and the fact that it is also not supported on Windows Server 08, you are really not going to get much help if a real issue happens to this server.

I also see that you are going to "try" all of this with a x32 version of SQL on an x64 OS ... which scares me even more - lol.

That being said, SQL 2000 "should" be able to run with some careful tweaking.

Not sure how the x32 SQL will play with the wide open memory of the x64 OS.




Thanks

J. Kusch

 

[mrdenny]

32bit SQL on 64bit OS has the same memory setups as if the OS was 32bit. You'll still have to use AWE to get over 2 Gigs of RAM.

Why not use Windows 2003 x64 with SQL 2000 Enterprise x64?

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog

 

[paul1979]

Yeah, thought it might be a bit dodgy to try

Company has deep pockets & short arms... Might have to tell them to stop being so tight & shell out for 2005!!

 

[mrdenny]

If you need x64 SQL 2000 you should be able to download it from the licensing website which someone should have access to under your volume license agreement (assuming you have one).

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog