Home Forums SQL Server 2008 SQL Server 2008 - General how do i upgrade my sql server 2008 r2 x86 to sql server 2008 r2 x64 ? RE: how do i upgrade my sql server 2008 r2 x86 to sql server 2008 r2 x64 ?

  • October 15, 2012 at 6:36 am

    #1549096

    Uninstall the 32-bit version. Install the 64-bit version. Take backups of the system databases and detach all user databases before then after you've installed the 64-bit restore the system DBs and attach the user DBs.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass