MSSQL_ENG014157
Message Details
Product Name |
SQL Server |
Product Version |
10.0 |
Product Build Number |
|
Event ID |
14157 |
Event Source |
MSSQLSERVER |
Component |
SQL Server Database Engine |
Symbolic Name |
|
Message Text |
The subscription created by Subscriber '%s' to publication '%s' has expired and has been dropped. |
Explanation
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 Abonelik bitiş ve etkinliğini kaldırmayı.
User Action
The subscription must be re-created and initialized before the Subscriber can begin receiving data changes again:
For information about creating subscriptions, see Yayın için abone olma.
For information about initializing subscriptions, see Bir abonelik başlatılıyor.
If the subscription database contains changes that have not been synchronized with the Publisher, you can use the tablediff yardımcı programı to determine which rows are different in the publication and subscription databases. For information, see Bir birleştirme abonelik süresi doldu ve bu değişiklikleri karşıya yüklenen gerekir.
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 Abonelik bitiş ve etkinliğini kaldırmayı.