SQL server 2000 64bit Setup Error
-
Tuesday, January 22, 2013 2:45 PM
Dear all,
We are planning to Migrate SQL environment from one DB server to Another...
Current Environment:
Itanium based server, 250 GB RAM,
Windows server 2003 Datacenter edition (64)
SQL server 2000 64bit ... Configured Memory utilization to use full 250 GB
New Environment
Xeon 7500 Processor family
350 GB RAM
Windows server 2003 Datacenter edition
My Question:
To my knowledge... sql server 2000 64 bit is only released for Itanium right?, which means i wont be able to install the sql 2000 64bit on the new environment?
So now... If I install the 32 bit version of sql server 2000.... is it possible to configure sql to utilize for e.g. 250 GB RAM? given that its supported by the OS? .....
Thanks
Saad
All Replies
-
Tuesday, January 22, 2013 3:41 PMModerator
Hello,
SQL Server 2012 Enterprise Edition will be able to use 64 GB of RAM when installed on Windows Server 2003 Data Center.I would recommend you to use the lock pages in memory policy
For more information:
http://msdn.microsoft.com/en-gb/library/aa366778(VS.85).aspx#physical_memory_limits_windows_server_2003
http://msdn.microsoft.com/en-us/library/aa933149(v=sql.80).aspx
http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/1bbea862-ecda-4ce1-80f1-5c2355382e09
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com -
Wednesday, January 23, 2013 12:58 AMModerator
Would you please check-out
http://msdn.microsoft.com/en-us/library/aa274596(v=sql.80).aspx
for details on SQL Server 2000 64 bit.
FAQ
----
Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.
-
Wednesday, January 23, 2013 10:32 AMModerator
Hello,
You are receiving that error because you are trying to install the IA64 version of SQL Server 2000 Enterprise. Please try to obtain the x86 version of Enterprise Edition.
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com -
Wednesday, January 23, 2013 10:34 AM
Can SQL 2000 32bit be configured to utilize 250GB RAM ?
as the OS is able to see the whole memory
-
Wednesday, January 23, 2013 11:37 AMModerator
Hello,
The maximum is 64 GB for SQL Server 2000 Enterprise Edition. It cannot access more memory.
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com- Marked As Answer by sl5 Wednesday, January 23, 2013 12:35 PM
-
Wednesday, January 23, 2013 11:58 AMSo only SQL 2000 IA64 can have more than 64GB correct?
-
Wednesday, January 23, 2013 1:39 PMModerator
Hello,
No, even on Itanium SQL Server 2000 Enterprise is limited to 64 GB. Please take a look at the following article:
http://msdn.microsoft.com/en-us/library/aa933149(v=SQL.80).aspx
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
.png)
