The READ_ONLY_ROUTING_URL '%.*ls' specified for availability replica '%.*ls' is not It does not follow the required format of 'TCP://system-address:port'. For information about the correct routing URL format, see the CREATE AVAILABILITY GROUP 19401 16 docum The availability replica '%.*ls' specified in the READ_ONLY_ROUTING_LIST for availability replica '%.*ls' does not exist. Only availability replicas that belong to the specified availability group '%.*ls' can be added to this list. To get the 19403 16 names of ava Failed to create, join or add May occur if AG involves two or more SQL failover instances. Check replica to availability group possible owners of SQL resource on both/more so as to verify no node '%.*ls', because node '%.*ls' is a name overlap. There should not be node-overlap. possible owner for both replica TSQL: SELECT * FROM sys.dm_os_cluster_nodes; '%.*ls' and '%.*ls'. If one replica is Powershell: get-clusterownernode -resource "XXXBSQL" failover cluster instance, remove Powershell: set -clusterownernode -resource "XXXASQL" -owners the overlapped node from its 19405 16 possible owners and try ag The state of the local availability If the changed is PRIMARY_PENDING, then check replica in availability group '%.*ls' sys.dm_hadr_database_replica_states. If database_state_desc = has changed from '%ls' to '%ls'. RECOVERY_PENDING (synchronization_health_desc will be The replica state changed because NOT_HEALTHY), then try DATABASE db SET HADR RESUME;”. “ALTER of either a startup, a failover, a Else if this is the only replica (no secondary replica), then (consider first communication issue, or a cluster taking a database snapshot as a backup if required) try “ALTER error. For more information, see DATABASE db SET HADR OFF;” to remove AlwaysOn so as to then 19406 10 the availabi
19401 16 The READ_ONLY_ROUTING_URL '%.*ls' specified for availability replica '%.*ls' is not It does not follow the required format of 'TCP://system-address:port'. For information about the correct routing URL format, see the CREATE AVAILABILITY GROUP docum 19403 16 The availability replica '%.*ls' specified in the READ_ONLY_ROUTING_LIST for availability replica '%.*ls' does not exist. Only availability replicas that belong to the specified availability group '%.*ls' can be added to this list. To get the names of ava 19405 16 Failed to create, join or add replica to availability group '%.*ls', because node '%.*ls' is a possible owner for both replica '%.*ls' and '%.*ls'. If one replica is failover cluster instance, remove the overlapped node from its possible owners and try ag May occur if AG involves two or more SQL failover instances. Check possible owners of SQL resource on both/more so as to verify no node name overlap. There should not be node-overlap. TSQL: SELECT * FROM sys.dm_os_cluster_nodes; Powershell: get-clusterownernode -resource "XXXBSQL" Powershell: set -clusterownernode -resource "XXXASQL" -owners 19406 10 The state of the local availability replica in availability group '%.*ls' has changed from '%ls' to '%ls'. The replica state changed because of either a startup, a failover, a communication issue, or a cluster error. For more information, see the availabi If the changed is PRIMARY_PENDING, then check sys.dm_hadr_database_replica_states. If database_state_desc = RECOVERY_PENDING (synchronization_health_desc will be NOT_HEALTHY), then try “ALTER DATABASE db SET HADR RESUME;”. Else if this is the only replica (no secondary replica), then (consider first taking a database snapshot as a backup if required) try “ALTER DATABASE db SET HADR OFF;” to remove AlwaysOn so as to then
troubleshooting-sql-server-alwayson-v1-1.docx