SQL AlwaysOn configuration completely disappear

Question

SQL AlwaysOn configuration completely disappear

Mad-Dog

SSCertifiable

Points: 6117
More actions
April 4, 2023 at 1:09 pm

#4168953
Hi,
I've SQL 2019 STD with CU16 on Win 2019 STD. i had some ESXI host unresponsive for 5 sec and the SQL AlwaysOn become completely malfunction that both my SQL Server the databases that are part of the AlwaysOn are i the state of restoring. the "funny" thing is that the AlwaysOn configuration completely disappear from both server. there was nothing in those DMV sys.dm_hadr_availability_group_states ,sys.availability_groups ,sys.availability_groups_cluster,sys.dm_hadr_availability_replica_states ,sys.availability_replicas ,sys.dm_hadr_availability_replica_cluster_states .
how this can be happened?
THX
- This topic was modified 1 year, 8 months ago by Mad-Dog.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

onetsql Valued Member Points: 57 More actions · Answer 1

We had a similar issue but it only dropped the AG from one of the replica's recently which was bad enough. Take a read of the following article and see if you have any of the errors listed in the article. In "rare" situations SQL will drop a replica from an AG.

https://techcommunity.microsoft.com/t5/sql-server-support-blog/issue-replica-unexpectedly-dropped-in-availability-group/ba-p/318175

We had to drop the AG from the node that used to be secondary and recreate the AG. I'm guessing you had to create the AG from scratch to restore service?

There are a couple of other recent posts on here with people also experiencing vanishing AG's.

Jeff Moden SSC Guru Points: 1004403 More actions · Answer 2

onetsql,

Nice link. Thanks.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)