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

  • 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 .

Viewing 0 posts

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