Posted by Erland Sommarskog on 11/07/07 22:46

Jeremy Pavleck (jpavleck@gmail.com) writes:
> Just curious if it's possible, and supported, to upgrade SQL 2005 from
> 32bit to 64bit. This is on top of Windows 2003 64bit. Trying to get
> the proper supported config for OM2k7 without blowing everything away.

This should have been detailed on
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/702359c4-6ca9-42a8-860c-a95a802898a1.htm
in Books Online. However, I can't find a final word on this. It says that
you cannot upgrade from SQL 2000 32-bit to SQL 2000 x64.

But in lieu of the affirmative, my answer has to be no.

However, you can always move databases with backup/restore or detach/attach
from x86 to x64.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]