Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Windows 2003+SQL 2005 cluster in place upgrade

Author  Topic 

nimesh.mathews
Starting Member

2 Posts

Posted - 2010-07-14 : 00:45:34
I am having a weird situation to upgrade a cluster. The cluster is an active-active windows 2003 having 2 instances of sql cluster. My client wants them to be upgraded in place both.

Is it a preferred method ?

anyone has tried this option...the draft plan is like this...

1) Failover all the resources to one node
2) Evict one node from the cluster and remove all the SAN links and built it as a single node cluster with Windows 2008 and SQL 2008 with the same instance names
3) Move the databases to SQL 2008
4) repeat the steps for the other node also...

Is this plan worth a try ?

Regards
Nimesh

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-14 : 01:01:05
That is a very risky plan. An in place upgrade is not advisable nor is evicting nodes.

Have you tested your method in a test environment?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -