I have a "working" Replication Set in SQL 2005 that we use in house to our users at remote branches on SQL Express 2005. I want to apply a filter to our biggest Set to help minimize the bandwidth impact. What I am asking is what considerations do I need to take into account before throwing a filter on there. Will it cause any issues I should be aware of? Does it affect compression adversely. Will everyone need to reinitialize after applying it?
Any heads up or insight would be appreciated.
Here is a snapshot showing where the Compression setting is that I am talking about.
Also, I could include a shot of the zipped snapshots if necessary.
Thanks for the help.