Server Fault is a question and answer site for system and network administrators. 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

I have an existing publication that has aroung 15 articles (tables) Some of these tables have 2+ million rows, so obviously, I would like to filter them.

If I set a filter on some of these, will I need to re-initialize the publication before it's effective?

share|improve this question
up vote 0 down vote accepted

The answer, as i found out, is yes.

share|improve this answer

For tables (articles) with existing data I believe you will need to re-initialize. If you are adding new articles you may be able to use the the @force_reinit_subscription parameter of sp_addmergefilter to add a filtered article without requiring a re-initialization.

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.