SQL Always on connectivity

Question

Dear experts, we have a SQL database configured in always on environment. Today morning, our database switch from A server to B server automatically and we found nothing in SQL log. I want to know how to check it.

Then, when databases are on B server and users are connected to it, after several seconds, users all get disconected and we found below error in the log "Unable to access availability db because the db replica is not in the PRIMARY or SECONDARY role"

I want to know why databases get switched automatically and why users get disconnected？

Answer 1

Hi @xhope ，

I want to know how to check it.

I guess that your demand is to check the error log.

I want to know why databases get switched automatically and why users get disconnected？

If the databases switch, which means some error happens you need to check the error log and see what's going on.
I suppose that the shared disk or node falling down .......... too many possibilties

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

Answer 2

Please see the log at the Windows operating system level as explained here.