Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I go to publication properties and General Tab in that. I see an option

Subscription expire and may be dropped if not synchronized in the following number of days. Replication meta data is kept for this amount of time.

Here some day is set, i.e. 7.

Now I am trying to change this figure to something else, i.e. 20. So If I make this change will the existing subscription reinitialize?

share|improve this question

No the subscription will not reinitialize when you make this change. This setting simply tells the distributor how far behind the subscription can get before the subscription will be automatically expired.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.