February 12, 2009 at 12:59 am
Hi,
I've SQL Server 2000 32BIT on Windows Server 2003 64BIT.
can i upgrade this instance of sql server 2000 32BIT into SQL Server 2005 64BIT?
THX
February 12, 2009 at 2:09 am
Upgrading 32 bit server to 64 bit server is not supported. You’ll need to install the 64 bit version and move the databases, logins, jobs, etc’ to the new SQL server (the 64 bit). I recommend that you’ll read about the difference about 32 bit and 64 bit versions. You can read about it at http://msdn.microsoft.com/en-us/library/aa274595(SQL.80).aspx
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 13, 2009 at 2:40 am
It is very likely your 32-bit SQL Server 2000 instance is running on a 32-bit edition of Windows. All 64-bit editions of SQL Server will only run on 64-bit editions of Windows, so you will need to reinstall Windows as part of your move.
The best way to plan this is to get a new server for your 64-bit install. You can then build and test the new server withuot impacting what is done on the existing server.
When you want to cut over to the new server, you can backup up your databases on SQL 2000 and restore them to SQL 2005. Alternatively you can detach your databases from SQL 2000, move the files to your new server, then attach them to SQL 2005, but detach/attach is slightly more risky as you cannot revert back to SQL 2000 if there a problem appears immediately after you go live.
Once you are live on SQL 2005, you can release the original server for re-use.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 13, 2009 at 2:55 am
hi,
the sql server 2000 is 32bit but the server that it is running on is definitely 64bit, and according to the post above you i cannot upgrade an sql server 32bit into 64bit.
THX
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply