Asked By
aldiaz
10 points
N/A
Posted on - 02/12/2012
I am currently using SQL Server 2008 min 32-bit, and I need any ideas on how to migrate the database from a 32-bit computer to a 64-bit computer because I've recently purchased SQL standard Server 2008 in 64-bit and I am planning to use that from now on. I'd really appreciate any help that I can get. Thanks!
SQL Server Update from 32-bit to 64-bit
Â
Dear Aldiaz,
Â
It will be easier that u r going to upgrade to the same SQL server version which is 2008. Simply u need to do 2 steps: reinstall and attach. Please try to follow the upcoming steps:
Â
-
Make sure that all users, services and applications are off the system for the upcoming duration.
-
Backup all databases and detach the user databases (to ensure consistency it does a checkpoint).
-
Copy the mdf/ldf files for both user and system databases.
-
Uninstall SQL Server 2008 32 bit to make the instance name available.
-
Install SQL Server 2008 64 bit with the same instance name and with the exact same version of the 32 bit one.
-
Restore master, msdb and model.
-
Now attach all the user databases.
-
Apply the Service Pack and Cumulative update.
-
Take full backups.
Â
Hope this may help you.
Â
Best of luck.
Answered By
lee hung
75 points
N/A
#99102
SQL Server Update from 32-bit to 64-bit
I've reviewed your problem and there is an easy solution for it. I have done a similar thing in the past for myself, I've done x86 –> x64 conversion and still haven't come across any issue.
So basically all you have to do, is just simply detach and again attach your database when upgrading from 32-bit to 64-bit Windows. You won't come across any problem because the storage layer is the same for both SQL x86 and x64.
I'm sure this will help you, best regards.
Answered By
aldiaz
10 points
N/A
#99103
SQL Server Update from 32-bit to 64-bit
Hi,
I have updated my version of SQL and did full backup. I also restored master, msdb and model. seems to be working well for me.
Thank you for helping.
