| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
SQL Server error log (availability groups) |
Learn about the SQL Server error log events that affect an Always On availability group and which symptoms should lead to review of the error log. |
MashaMSFT |
mathoma |
06/13/2017 |
sql |
availability-groups |
reference |
[!INCLUDE SQL Server] 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 SQL Server 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).