Export (0) Print
Expand All

MSSQL_ENG014160

Product Name

SQL Server

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 Set Thresholds and Warnings in Replication Monitor and Programmatically Monitor Replication.

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

  • If the threshold has been exceeded, but the subscription has not yet expired, synchronize the subscription. For more information, see Synchronize Data.

  • If the agent has been running, but has not been replicating changes properly, this can cause the subscription to expire. For transactional replication, make sure that the Distribution Agent and Log Reader Agent are running. For merge replication, make sure the Merge Agent is running. For information about how to start these agents, see Start and Stop a Replication Agent (SQL Server Management Studio) and Replication Agent Executables Concepts.

  • If the subscription has expired, it must either be reinitialized or dropped and re-created, depending on the type of subscription and how long it has been expired. For more information, see Subscription Expiration and Deactivation.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft