Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

MSSQL_ENG014160

Product Name

SQL Server

Product Version

10.0

Product Build Number

 

Event ID

14160

Event Source

MSSQLSERVER

Component

SQL Server Database Engine

Symbolic Name

Message Text

The threshold [%s:%s] for the publication [%s] has been set. One or more subscriptions to this publication have expired.

Replication lets you enable warnings for several conditions. This includes imminent subscription expiration. Subscriptions can expire if they are not synchronized within a specified retention period. For more information, see Subscription Expiration and Deactivation.

When you enable a warning by using Replication Monitor or sp_replmonitorchangepublicationthreshold, you specify a threshold that determines when a warning is triggered. When that threshold is met or exceeded, a warning is displayed in Replication Monitor, and an event is written to the Windows event log. Reaching a threshold can also trigger a SQL Server Agent alert. For more information, see Setting Thresholds and Warnings in Replication Monitor and How to: Programmatically Monitor Replication (Replication Transact-SQL Programming).

The resolution for this issue depends on the reason the warning was raised:

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.