locked
sql 2005 cluster migration to sql 2008 cluster RRS feed

  • Question

  • Hi,

    We have sql 2005 active/pasive cluster runing on windows 2003 server 32 bit. We want to migrate to windows 2008 r2 and sql 2008. How could we do that?

    thanks

    • Moved by Shulei Chen Thursday, October 4, 2012 7:55 AM (From:Getting started with SQL Server)
    Wednesday, October 3, 2012 7:26 AM

Answers

  • Hi,

    Generally, you can upgrade the Windows Server 2003 to Windows Server 2008 R2 first, for more details, please refer to this article: In-Place Migration for a Two-Node Cluster. And then upgrade to SQL Server 2008 Failover Cluster instance as Uri mentioned.

    But according to your description, you are using Windows Server 2003 32-bit, and Windows Server 2008 R2 ships with a 64-bit SKU only. So I’m afraid that you cannot do that upgrade. Please take a look at this article: Windows Server 2008 R2 Upgrade Paths. It says: Cross-architecture in-place upgrades (for example, x86 to x64) are not supported.

    Besides, if you encounter any Windows Server related issues, I would like to recommend you to post a new thread on Windows Server Forums.


    Best Regards,
    Ray Chen

    • Proposed as answer by Alberto MorilloMVP Thursday, October 4, 2012 11:06 AM
    • Marked as answer by Shulei Chen Wednesday, October 10, 2012 9:59 AM
    Thursday, October 4, 2012 7:56 AM

All replies