I have SQL Server, which is currently x86, and I would like to upgrade it to x64. It runs on a 64-bit version of Windows, and I think it is as simple as the wrong version installed when setting up the server. This is a production server, so my biggest problem is that the logins remain unchanged since each user has their own SQL login. I did a few searches and found an Expert-Exchange thread that gave the following steps, although it never reported this if it worked.
- separate databases - alluser dbs, model and msdb.
- script logins ( http://support.microsoft.com/kb/918992/ ) and tasks
- save db files and scripts
- unintall SQL
- install sql x64
- attach dbs
- re attaches dbs when the files are in the right place.
- run scripts for logins and tasks if msdb is not connected.
Besides the fact that you do not need to transfer the system databases to a new instance (so step 1 is not quite correct, except for the scripts of any special XP or anything else that you created), can someone think of what else you need to do? More importantly, has anyone really tried this? Can you talk about any stories or gotchas, or did it go smoothly?
source
share