Migrating Microsoft SQL Server instance 32 bit to 64 bit machine

Posted on 2011-04-18
Last Modified: 2012-05-11
Hi Experts,
I am a system admin and I would like to migrate a 32 bit version of sql server 2008 standard to a 64 bit version (New Hardware) due to the sunsetting of existing hardware.  
What is the best way of doing this avoiding the pitfalls?

Thanks in advance
Question by:chrislindsay
    LVL 32

    Assisted Solution


    A good approach is to take a full backup of your database and restore it on the new server.

    Author Comment

    Hi what about all the jobs \ security settings etc.  Is it a matter of migrating all the components manually ?
    Is there no migration tool?
    LVL 17

    Accepted Solution

    You can also backup and restore msdb which will bring over all scheduled jobs.  Any custom security is something you will have to handle manually.  

    When moving to other hardware you could use the Copy Database wizard but I don't suggest it.
    LVL 28

    Assisted Solution

    by:Ryan McCauley
    A backup/restore of the MSDB can cause other issues though - it's breaks some kind of broker that stops DBMail from working, and you have to reset it using a few backdoor SQL queries. The MSDB contains all the SQL Agent jobs, and those can be scripted.

    I'd move your logins first (there's a Microsoft script for it:, and then backup/restore your databases. Once that's done, execute any needed scripts to create SQL agent jobs, maintenance plans, or any special configurations (DBMail, replication, etc).

    Author Closing Comment

    All good partial solutions.  Thanks

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now