Need to know Failover process : Veritas software/storage upgrade in sql server 2005/windows 2004 sp2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Need to know Failover process : Veritas...

Need to know Failover process : Veritas software/storage upgrade in sql server 2005/windows 2004 sp2

Rate Topic

Display Mode

Topic Options

Author

Message

SQLDBA346

Posted Thursday, February 21, 2013 10:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 11:35 AM
Points: 3, Visits: 593

I would like to know the steps while doing software upgrade on sql server cluster environment.

I got request to support as DBA while software team going to upgrade veritas software /storage upgrade on windows server 2003 sp2. they asked to support to stop and start sql and cluster services on passive/active node.

cluster info :

Total physical node : 3

Node 1
Node 2
Node 3

total instance = 5
INT 1 preferred owner =2
INT 2 preferred owner =2
INT 3 preferred owner =1
INT 4 preferred owner =3
INT 5 preferred owner =3

Failover process:

As far as I know, when the server team will be ready to upgrade for node 1. I need to failover all resources to node 2 or node 3. disable all sql server services including cluster service on node 1 and allow software team to upgrade. Once i get green sign from software team I need to bring all services online and put them into original state means manual mode. and then failover resources back to node 1 . same process apply for node 2 and node 3.

Please let me know if i miss anything or this is right way to this.

thanks in advance .

Post #1422707

« Prev Topic | Next Topic »

Permissions