AvailabilityReplica.Role property is always "Unknown"?

Unanswered AvailabilityReplica.Role property is always "Unknown"?

  • lundi 6 août 2012 20:12
     
     

    Whenever I query AvailabilityReplica.Role property it is always “Unknown” for all the replica servers participating in the AAG except for the one that I’m making the call on.
    I do not see this problem when I make the call on primary replica server.

    Any idea why it behaves like this and how to get the right information? I do not want to make call to each replica server to get the details.

    See the output below.

    ----------------
    AAG details:
    ----------------
    AAG name: Lakers_Fluke
    AAG Parent: [fluke]
    AAG Primary Replica Server Name: LAKERS
    AAG State: Existing
    AAG Local Replica Role: Secondary
    ----------------
    REPLICA SERVERS FOLLOWS:
    ----------------

    Replica Server 1.

    AAG replica name: FLUKE
    AAG Parent: [Lakers_Fluke]
    AAG State: Existing
    AAG replica mode: AsynchronousCommit
    AAG SConnection tate: Connected
    AAG Operational State: Online
    AAG Role: Secondary

    Replica Server 2.

    AAG replica name: LAKERS
    AAG Parent: [Lakers_Fluke]
    AAG State: Existing
    AAG replica mode: AsynchronousCommit
    AAG SConnection tate: Unknown
    AAG Operational State: Unknown
    AAG Role: Unknown

    Replica Server 3.

    AAG replica name: WARRIORS
    AAG Parent: [Lakers_Fluke]
    AAG State: Existing
    AAG replica mode: AsynchronousCommit
    AAG SConnection tate: Unknown
    AAG Operational State: Unknown
    AAG Role: Unknown
    ----------------


    • Modifié HemC lundi 6 août 2012 20:13
    •  

Toutes les réponses

  • mardi 7 août 2012 23:04
     
     

    Here is my observation after connecting to a replica server through SMO and querying for AAG properties...

    If the replica server role is not primary, roles of other replica servers in the group are always unknown. If it is primary it gets me the roles of all serves correctly.

    Please help me with it.