SQL Server 2008 R2 元数据清理问题
我们使用 SQL Server 2008 R2 作为数据库，并使用它来同步不同位置的数据。我们可以设置订阅过期的时间间隔。但此订阅将在该到期日期之前到期。任何人都可以为此提供解决方案吗？
We use SQL Server 2008 R2 as our database and we use that to SYNC data in different locations. We can set the interval to expire the subscription. But this subscription is expiring before that expiring date. Can anyone give a solution for this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
该问题可能是由于未能设置分发数据库最大事务周期造成的。
如果订阅未在指定时间段内同步，则订阅可能会被删除，或者可能会自动标记为停用并需要重新初始化。它是过期并被删除还是被标记为停用并需要初始化取决于它是否超出了发布的订阅过期属性或分发数据库的最大事务保留属性以及它是否是匿名订阅。
这是历史信息和交易保留期限的结合决定的。此外，Microsoft 过去 (Sql Server 2005) 也记录了与合并复制订阅类似的问题。这些问题可能已在 SQL Server 2008 中得到修复。
The problem MAY be due to a failure to set the distribution database maximum transaction period.
If a subscription is not synchronized within a specified period of time, there is a possibility the subscription may get deleted or it may be automatically marked deactivated and require reinitialization. Whether it expires and is deleted or gets marked deactivated and requires initialization depends upon whether it exceeds the subscription expiration property of the publication or the maximum transaction retention property of the distribution database as well as whether or not it is an anonymous subscription.
Its a combination of the historical information and the transaction retention period that determines this. In addition, bugs have been logged with Microsoft in the past (Sql Server 2005) with similar issues with Merge Replication subscriptions. These MAY have been fixed in SQL Server 2008.