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.
Thanks,
JDP
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/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx