April 10, 2025 at 1:58 pm
All,
We have an environment where connecting to servers in SSMS requires an extra domain specification. Instead of ServerName\InstanceName, it's "ServerName.My.Other.Domain\InstanceName."
I am trying to test a manual AG failover process between data centers (DC) that requires me to alter the remote DC replicas from asynch to synch before the failover. But it keeps failing.
My code is such:
ALTER AVAILABILITY GROUP [BrandieDRTest] MODIFY REPLICA ON N'Server\Instance' WITH (AVAILABILITY_MODE = SYNCHRONOUS_COMMIT);
ALTER AVAILABILITY GROUP [BrandieDRTest] MODIFY REPLICA ON N'Server.My.Other.Domain\Instance' WITH (AVAILABILITY_MODE = SYNCHRONOUS_COMMIT);
I've tried both, logged into the primary node but the Server name is the other DC server\instance and I'm getting the error message:
Msg 35210, Level 16, State 14, Line 5
Failed to modify options for availability replica 'BrandieDRTest' in availability group 'Server\Instance'. The specified availability group does not contain an availability replica with specified name. Verify that availability group name and availability replica name are correct, then retry the operation.
The replicas do exist. I can see them in SSMS GUI. I'm pretty sure the problem is this extra domain information, but I cannot figure out the work around. This is driving me nuts. Any thoughts?
April 11, 2025 at 2:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
April 14, 2025 at 11:42 am
"The specified availability group does not contain an availability replica with specified name"
I would triple check for typing errors in the replica sql instance name.
If I'm correct, this statement should be executed using a connection on the primary ag server or listener
--Check with this query which server instance hosts the primary replica:
SELECT ag.name AS AvailabilityGroupName
, ar.replica_server_name AS ReplicaServerName
, rs.role_desc AS ReplicaRole
FROM sys.availability_groups AS ag
INNER JOIN sys.availability_replicas AS ar
ON ag.group_id = ar.group_id
INNER JOIN sys.dm_hadr_availability_replica_states AS rs
ON ar.replica_id = rs.replica_id;
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 14, 2025 at 1:44 pm
I feel so embarrassed. It was a typo. Tiny tiny typo. My eyes went past it so many times.
Thanks for your response.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply