-1

In the below window to configure an Always On Availability Group secondary, in the "Readable Secondary" column, what's the difference between "Readable Secondary" = 'Yes' and 'Read-intent only'?

enter image description here

closed as too broad by dezso, Marco, hot2use, McNets, Philᵀᴹ Sep 4 '17 at 15:44

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 3
    I think more context is needed. What database (and version) are you referring to? Have you tried checking the docs? What do they say that you don't fully understand? – joanolo Sep 4 '17 at 5:49
2

From here:

Read-intent only

Only read-only connections are allowed to secondary databases of this replica.
The secondary database(s) are all available for read access.

Yes

All connections are allowed to secondary databases of this replica, but only for read access.
The secondary database(s) are all available for read access.

They might sound like they're the same, but the "Yes" means that people can connect even if they don't specify ApplicationIntent=ReadOnly in their connection string. This can be useful for legacy applications where the connection string can't be modified.

It's up to you, though, to make sure that the app doesn't try to do any writes. If it does, those queries will simply fail.

Read-intent only is a safer alternative when you know your apps have all been modified with ApplicationIntent=ReadOnly in their connection string. That way, if an app accidentally tries to connect to the wrong place, you know it'll fail right at connection time and choose another replica immediately - rather than trying to start transactions that fail.

  • Thanks O (Oreo) and BO (Brent Ozar); that helps and is useful info. This is now answered and can be closed with an up vote. – Prashant Sep 4 '17 at 13:28
  • @Prashant you're welcome. To indicate that the answer is accepted, click the check mark beside the answer. – Brent Ozar Sep 4 '17 at 13:29
  • Nice additional info Brent! I think DBA StackExchange has a policy for new-ish users, where you can only mark something as an answer after 2 days of the question going up. – Oreo Sep 4 '17 at 13:48

Not the answer you're looking for? Browse other questions tagged or ask your own question.