Post reply

Do Reads get re-directed from Secondary Replica to Primary Replica ?

  • August 9, 2012 at 10:14 am

    #265803

    Hello Fellas,

    I have setup Always-ON AG on my SQL 2012 RTM instance and I have 2 databases as part of my AG.

    DB1 and DB2 for instance.

    These are setup on Primary Replica as Read-Write and Secondary Replica as Readonly.

    I have a Listener [ VNN ] setup and my primary application points to my Listener to connect to the AG.

    Now, I have another reporting application which points to the same VNN with Applicationintent=Readonly in the connectionstring and so is re-directed to my Secondary Replica since the DBs are readonly.

    If for instance, my secondary replica becomes unavailable, will my application be re-directed to Primary replica for read calls or will my read calls fail ?

    Please suggest.

    Thanks

    Kishore

  • August 11, 2012 at 10:56 am

    #1524788

    Any idea folks? 🙂

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

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