| title | SQL Server error log (availability groups) |
|---|---|
| description | 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. |
| author | MashaMSFT |
| ms.author | mathoma |
| ms.date | 06/13/2017 |
| ms.service | sql |
| ms.subservice | availability-groups |
| ms.topic | 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).