SQL Server error log

error log (Always On

The SQL Server error log reports events affecting Always On Availability Groups, such as:

Communication with the Windows Server Failover Clustering (WSFC) cluster

State transitions of availability replicas

State transitions of availability databases

Connectivity state of availability databases between primary and secondary replicas

Statuses of the availability group endpoints

Statuses of the availability group listeners

Lease status between the SQL Server resource DLL (running in the WSFC cluster) and the

instance (for more information, see

How It Works: SQL Server Always On lease

timeout

)

Error events in the availability group

The following symptoms should lead to review of the SQL Server error log:

Cannot access availability databases

Unexpected availability group failover

Availability group in the Resolving state unexpectedly

Availability group in an indeterminate state

For more information, see

View the SQL Server error log (SQL Server Management Studio).