sql 2005 64 bit upgrade | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql 2005 64 bit upgrade

Does anyone know if it’s possible to detach/backup a database on sql server 2000 and attach/restore on sql server 2005 64 bit? I’m pretty sure it works just fine if sql server 2005 is 32 bit, but I want to try 64 bit. I’m not sure whether I can migrate a 32 bit database to a 64 bit one. Thanks.
According tohttp://www.microsoft.com/sql/solutions/ssm/migratingto64bit.mspx &http://www.microsoft.com/sql/editions/64bit/datasheet.mspx it should work as expected. I haven’t tried but the link references it. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>