• I Only set yes for readable seconday :

    And I read about Read only Routing. Are these Comparison (Between Read only And Read only Routing) true?

    1- In read Only secondary (where we have a Listener)

    - Our App Connect to Listener.

    - Listener Lead app to Primary.

    - All Connection , received by the primary And if we want to Reports-App connection To Secondary, We should do this manualy.

    - Both servers (Primary And secondary are available to connection from app or tsql from Sql server console)

    - If we have fail on primary , we have some seconds disconnection and then we connect to secondary as new primary

    2- In read-intent Only (where we have a listener and set a Readonly Routing)

    - Our App Connect to Listener.

    - Listener Lead (Update,insert and delete) Of app to Primary And (Select) of App to Secondary

    - some Connection , received by the primary and some by secondary. Automaticaly reports connect to Secondary

    - secondary are not accessible in any way.

    - and in fail primary, we dont have disconection

    Thank you for your paitience