Skip to content

sql-server-error-log-always-on-availability-groups.md

Latest commit

 

History

History
50 lines (33 loc) · 1.81 KB

sql-server-error-log-always-on-availability-groups.md

File metadata and controls

50 lines (33 loc) · 1.81 KB
title SQL Server error log (Always On Availability Groups) (SQL Server) | Microsoft Docs
ms.custom ag-guide
ms.date 06/13/2017
ms.prod sql
ms.reviewer
ms.suite
ms.technology high-availability
ms.tgt_pltfrm
ms.topic conceptual
ms.assetid 39d0c98d-75af-4dd1-b908-30d31af56f2a
caps.latest.revision 4
author rothja
ms.author jroth
manager craigg

SQL Server error log (Always On Availability Groups)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] 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).