Post reply

Always On--Readable Secondary Options

  • August 21, 2014 at 11:24 pm

    #292492

    Hi Experts,

    In always on under availability group server name properties can see the option Readable Secondary. In that for secondary server the Readable Secondary Option is YES and for Primary it is Read-Intent. I believe Read-Intent allows only read only connections and YES allows all user connections.

    Can someone please explain what exactly it means for the primary and secondary?

  • August 22, 2014 at 3:28 am

    #1740113

    post the solution i sent you by PM

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • August 22, 2014 at 8:55 am

    #1740281

    Thanks Perry for sharing the knowledge.

    Read-intent is not a Primary role option. The only options for the primary role are

    allow all connections, does what it says all connections are allowed

    allow read\write connections, this will basically reject any connections that are specifically set to ApplicationIntent=ReadOnly. Connections that are set to read\write or not specified will be allowed.

    Secondary role options are

    No, the database is not available for any connections what so ever, this is the default

    Read-intent only, only connections that specify ApplicationIntent=ReadOnly will be allowed

    Yes, all connections are allowed on a ReadOnly basis for the secondary databases in the group

    All replicas that are part of an AlwaysOn group will have a defined rule for the Primary role and a defined rule for the secondary role

  • August 22, 2014 at 9:16 am

    #1740291

    Read-intent is not a Primary role option. The only options for the primary role are

    • allow all connections, does what it says all connections are allowed
    • allow read\write connections, this will basically reject any connections that are specifically set to ApplicationIntent=ReadOnly. Connections that are set to read\write or not specified will be allowed.

    Secondary role options are

    • No, the database is not available for any connections what so ever, this is the default
    • Read-intent only, only connections that specify ApplicationIntent=ReadOnly will be allowed
    • Yes, all connections are allowed on a ReadOnly basis for the secondary databases in the group

    All replicas that are part of an AlwaysOn group will have a defined rule for the Primary role and a defined rule for the secondary role

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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