I have a machine windows 2003 server 64 bits, currently the sql 2005 server database installed is a 32 bit.
I am pondering to upgrade it to sql 2005 64 bits. Is it advisable to upgrade to sql 2005 64 bits ?
I wonder whether such upgrade is better to be done using (method 1)In-Placed or (method 2) Install another sql 2005 64 bit on the same machine and then do a migration of the 32 bit databases to 64 bit databases ?
For (method 2) can I do a backup and restore method of migrating all the User databases and the System Databases or should I do a deattach and attach method ?
Thanks in advance for your time in answering my query.