SQL Server Update from 32-bit to 64-bit

Asked By 10 points N/A Posted on -
qa-featured

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!

SHARE
Best Answer by tibor.tokie
Best Answer
Best Answer
Answered By 0 points N/A #99101

SQL Server Update from 32-bit to 64-bit

qa-featured

 

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 10 points N/A #99102

SQL Server Update from 32-bit to 64-bit

qa-featured

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 10 points N/A #99103

SQL Server Update from 32-bit to 64-bit

qa-featured

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.

Login/Register to Answer

Related Questions