Whether the disconnected state caused by session timeout is to be manually or automatically resolved?

All we need is an easy explanation of the problem, so here it is. Link: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-ver16#SessionTimeoutPerios Once the session timeout has expired, and it goes into a disconnected state, when…

Continue ReadingWhether the disconnected state caused by session timeout is to be manually or automatically resolved?

How does an async AG secondary sync itself with the primary when secondary missed tlog record due to a power failure on secondary server?

All we need is an easy explanation of the problem, so here it is. In a SQL AG (read-scale) async mode, which doesn't require a WSFC cluster, suppose the following…

Continue ReadingHow does an async AG secondary sync itself with the primary when secondary missed tlog record due to a power failure on secondary server?