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