Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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

 
discard

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.