Skip to content

Latest commit

 

History

History
49 lines (38 loc) · 1.96 KB

File metadata and controls

49 lines (38 loc) · 1.96 KB
title Availability database is suspended | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology high-availability
ms.topic conceptual
f1_keywords
sql12.swb.agdashboard.drp1notsuspended.issues.f1
helpviewer_keywords
Availability Groups [SQL Server], policies
ms.assetid 6baee70f-848c-4e86-b20d-78875c0f82cb
author MashaMSFT
ms.author mathoma
manager craigg

Availability database is suspended

Introduction

Policy Name Availability Database Suspension State
Issue Availability database is suspended.
Category Warning
Facet Availability database

Description

This policy checks the state of data movement of the secondary database (also known as a "secondary database replica"). The policy is in an unhealthy state when the data movement is suspended. The policy is otherwise in a healthy state.

Note

For this release of [!INCLUDEssCurrent], information about possible causes and solutions is located at Availability database is suspended on the TechNet Wiki.

Possible Causes

Data synchronization on this availability database might have been suspended because of the following:

  • Due to an error, the system might have suspended data synchronization.

  • The database administrator might have suspended data synchronization for maintenance purposes.

Possible Solution

Resume data synchronization. If the issue persists, check the availability group in the Event log, and then diagnose why the system suspended data movement.

See Also

Overview of AlwaysOn Availability Groups (SQL Server)
Use the AlwaysOn Dashboard (SQL Server Management Studio)