Post reply

Upgrade 3 node a/p/a windows 2003 cluster with SQL Server 2005 to windows 2008 R2 cluster with SQL Server 2008

  • February 2, 2011 at 11:10 am

    #231026

    Hi,

    We have 3 node a/p/a cluster setup for SQL Server 2005 on Windows 2003 R2.

    Node1 has 2 instances and node3 3 instances and node2 is passive

    Now,we want to upgrade Windows 2003 to 2008 and SQL server 2005 to SQL Server 2008 and we need to use the same hardware.

    Could you please advice me the best way to achieve this?

  • February 2, 2011 at 2:42 pm

    #1281643

    To upgrade on same hardware, generally in place migration sounds like a best option. However, I personally would not suggest in place migration. But I would suggest that you build complete new server.

    Take last time full backups, detach the database files and keep it on other drive or server. Make sure you export the settings from MSDB and Master databases. (There are standard scripts from Microsoft which will help you export logins/users/jobs/ssis etc, you may google that).

    Rebuild the machine with new OS and SQL Server. Restore the settings in Master and MSDB. Once you do that you have re-attach the database files to the server. Look for orphaned users and map them with logins, if any. Verify all ssis and jobs are set.

    Swarndeep

    http://talksql.blogspot.com

Viewing 2 posts - 1 through 1 (of 1 total)

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