SQL Server Update from 32-bit to 64-bit

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!

• Status: Open
• Question Views: 2007
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by tibor.tokie

Go To Solution

Best Answer

Best Answer

Answered By tibor.tokie 25 points N/A #99101

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.

About tibor.tokie

Questions
1

Answers
157

Best Answers
24

• Vote Up 0 Vote Down

• Posted on - 02/12/2012
• Question Category: MySQL Server

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.

About lee hung

Questions
3

Answers
1451

Best Answers
463

• Vote Up 0 Vote Down

• Posted on - 03/28/2012
• Question Category: MySQL Server

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.

About aldiaz

Questions
13

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/01/2012
• Question Category: MySQL Server