开发者

SQL Server 2005 Merge Replication: Under what circumstances would the base snapshot expire?

开发者 https://www.devze.com 2023-01-01 09:31 出处:网络
Obviously changing schema, adding / removing published articles etc expires the snapshot, but is there anything else that would ca开发者_C百科use the publication to expire?

Obviously changing schema, adding / removing published articles etc expires the snapshot, but is there anything else that would ca开发者_C百科use the publication to expire?

We're seeing a snapshot expiring without any changes to schema or data on the server.

If a snapshot is older than the subscription expiration, would that cause it to be expired?


To answer my own question:

The snapshot expires when:

  • Any schema change or any change to the publication properties
  • When the snapshot is older than the subscription expiration

NB: When you create the publication, sql creates a sql agent job that runs every 14 days (the default subscription expiration period). If you subsequently change the expiration period (e.g. to 7 days), the schedule of this job is not updated, and needs to be manually done, otherwise you risk getting snapshot obsolete errors.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号