Skip to content

Commit 821ea17

Browse files
committed
Merge branch 'master' of https://github.com/MicrosoftDocs/sql-docs-pr into ADS
2 parents a878fec + e3c8167 commit 821ea17

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

docs/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -122,7 +122,7 @@ ms.author: mathoma
122122

123123
- **Read-only access to one or more secondary replicas (readable secondary replicas)**
124124

125-
Any availability replica can be configured to allow read-only access to its local databases when performing the secondary role, though some operations are not fully supported. Also, if you would like to prevent read-only workloads from running on the primary replica, you can configure the replicas to allow only read-write access when running under the primary role. For more information, see [Active Secondaries: Readable Secondary Replicas (Always On Availability Groups)](../../../database-engine/availability-groups/windows/active-secondaries-readable-secondary-replicas-always-on-availability-groups.md).
125+
Any secondary availability replica can be configured to allow only read-only access to its local databases, though some operations are not fully supported. This will prevent read-write connection attempts to the secondary replica. It is also possible to prevent read-only workloads on the _primary_ replica by only allowing read-write access. This will prevent read-only connections from being made to the primary replica. For more information, see [Active Secondaries: Readable Secondary Replicas (Always On Availability Groups)](../../../database-engine/availability-groups/windows/active-secondaries-readable-secondary-replicas-always-on-availability-groups.md).
126126

127127
If an availability group currently possesses an availability group listener and one or more readable secondary replicas, [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] can route read-intent connection requests to one of them (*read-only routing*). For more information, see [Availability Group Listeners, Client Connectivity, and Application Failover (SQL Server)](../../../database-engine/availability-groups/windows/listeners-client-connectivity-application-failover.md).
128128

0 commit comments

Comments
 (0)