Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER AVAILABILITY GROUP aggroup
- MODIFY REPLICA ON 'node1'
- WITH
- (
- PRIMARY_ROLE
- (
- READ_ONLY_ROUTING_LIST= ('node2','node3','node1')
- )
- );
- SELECT AVGSrc.replica_server_name AS SourceReplica
- , AVGRepl.replica_server_name AS ReadOnlyReplica
- , AVGRepl.read_only_routing_url AS RoutingURL
- , AVGRL.routing_priority AS RoutingPriority
- FROM sys.availability_read_only_routing_lists AVGRL
- INNER JOIN sys.availability_replicas AVGSrc ON AVGRL.replica_id = AVGSrc.replica_id
- INNER JOIN sys.availability_replicas AVGRepl ON AVGRL.read_only_replica_id = AVGRepl.replica_id
- INNER JOIN sys.availability_groups AV ON AV.group_id = AVGSrc.group_id
- ORDER BY SourceReplica
Add Comment
Please, Sign In to add comment