Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Product Name

SQL Server

Event ID


Event Source



SQL Server Database Engine

Symbolic Name

Message Text

The subscription created by Subscriber '%s' to publication '%s' has expired and has been dropped.

A Subscriber must synchronize with the Publisher within the time specified in the publication retention period. If a Subscriber does not synchronize within this period, the subscription expires. For more information, see Subscription Expiration and Deactivation.

The subscription must be re-created and initialized before the Subscriber can begin receiving data changes again:

If the subscription database contains changes that have not been synchronized with the Publisher, you can use the tablediff Utility to determine which rows are different in the publication and subscription databases.

You can increase the publication retention period to avoid having subscriptions expire. Use caution in setting a high value, because this can result in more data and metadata being stored, which affects performance. For more information, see Subscription Expiration and Deactivation.

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

Community Additions

© 2015 Microsoft