Guest User

Untitled

a guest
Nov 18th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. ALTER AVAILABILITY GROUP aggroup
  2. MODIFY REPLICA ON 'node1'
  3. WITH
  4. (
  5. PRIMARY_ROLE
  6. (
  7. READ_ONLY_ROUTING_LIST= ('node2','node3','node1')
  8. )
  9. );
  10.  
  11. SELECT AVGSrc.replica_server_name AS SourceReplica
  12. , AVGRepl.replica_server_name AS ReadOnlyReplica
  13. , AVGRepl.read_only_routing_url AS RoutingURL
  14. , AVGRL.routing_priority AS RoutingPriority
  15. FROM sys.availability_read_only_routing_lists AVGRL
  16. INNER JOIN sys.availability_replicas AVGSrc ON AVGRL.replica_id = AVGSrc.replica_id
  17. INNER JOIN sys.availability_replicas AVGRepl ON AVGRL.read_only_replica_id = AVGRepl.replica_id
  18. INNER JOIN sys.availability_groups AV ON AV.group_id = AVGSrc.group_id
  19. ORDER BY SourceReplica
Add Comment
Please, Sign In to add comment