upgrade Windows 2003 sql 2005 32bit server to Windows 2008R2 x64

  • I need to upgrade our server from 2003 to 2008 and would like to go to R2 which is x64 only. Does anyone have any experience or knowledge with performing this task? From what I read online it looks like it should upgrade with out issue.

    Best bet is to build out new server but because of the old applications on this system I really want to avoid doing this.

    Thoughts?

  • Do you have support for the old applications? If they can reproduce a parallel environment I would recommend you do so and test the upgrade.

    Other option is is there an upgraded version of the application that will actually take advantage of newer OS and DB version. If yes, then do out-of-place like you said.

    In summary I believe you need the app guys.

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • I'm really not fond of OS upgrades, plus the hardware's probably ancient and in need of replacing.

    Besides:

    https://technet.microsoft.com/en-us/library/dd979563%28v=ws.10%29.aspx

    Cross-architecture in-place upgrades (for example, x86 to x64) are not supported.

    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
  • Hardware is a virtual machine so this is not a problem.

    I may have to look at 2008 x32 until we can schedule the application upgrades which could be years. Thanks for the link to that Microsoft document.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply