locked
Upgrade RRS feed

  • Question

  • Hi,

    Can we in-place upgrade SQL Server 2005 Standard Edition, 32bits to SQL Server 2008 R2 standard edition 64 bits?

    Thanks

    • Moved by Tom Phillips Thursday, March 14, 2013 9:37 PM Upgrade question
    Thursday, March 14, 2013 9:00 PM

Answers

  • No,  in place upgrade from a 32 bit SQL to 64 bit SQL is not supported. However, you  can do a backup of existing 32 bit user databases and restore them to a new 64 bit SQL Server instance.
    Thursday, March 14, 2013 9:20 PM
  • This is not supported upgrade path, you cannot change processor architecture when doing inplace upgrades


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    Thursday, March 14, 2013 10:45 PM

All replies

  • No,  in place upgrade from a 32 bit SQL to 64 bit SQL is not supported. However, you  can do a backup of existing 32 bit user databases and restore them to a new 64 bit SQL Server instance.
    Thursday, March 14, 2013 9:20 PM
  • This is not supported upgrade path, you cannot change processor architecture when doing inplace upgrades


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    Thursday, March 14, 2013 10:45 PM