locked
In place cluster DB migration along with windows 2003 OS to Windows2008R2 RRS feed

  • Question

  • Hi,

    I have got an requirement to find feasibility of doing an in-place migration of the SQL 2005 databases currently configured as an Cluster SQL instance on Windows 2003 OS.

    The OS cluster is going to be upgraded from windows 2003 to windows 2008 R2 and requirment is to have the SQL2005 cluster instance upgraded in place  to 2008 R2.

    How different is this to be done in contrast to standalone where we do with normal 2008R2 setup file. Should we use the setup file on all the 3 windows 2003 servers and for cluster instance upgradation do we have different options to be selected.

    I have 2 instance of SQL 2005 currently running on the 3 windows 2003 servers as below

    26.abc.com

    27.abc.com

    28.abc.com

    As well what are the precautions to be taken, i have read that an inplace migration is not best practice as if it goes wrong we will have uninstall, clean up and rebuild the whole instance from backups and scripts.

    Wishes

    Eben

    Friday, February 19, 2016 7:27 AM

All replies

  • Sorry there are actually 3 SQL 2005 instances running on these 3 nodes and we need to upgrade all these 3 instances..
    Friday, February 19, 2016 8:06 AM
  • I got this KB from the MS Site and it appears has some values,should any of u have an idea and have worked out similiar or faced an issue, do let me know...

    https://support.microsoft.com/en-gb/kb/953200

    Thank you

    Tuesday, February 23, 2016 10:49 AM
  • Hi,

    You have answered it, the link is correct.

    Tuesday, March 8, 2016 8:57 AM