Hilary Cotter wrote:
> I'm confused. He goes offline, makes changes, syncs on day 7, on day
9 he
> syncs, and you want him to just receive the changes which occurred
between
> day 7 and day 9? This is precisely what happens. You can filter so he
only
> gets the data he needs.

> 1) this is the plain vanilla merge model - unless I am missing
something.
> 2) you don't need to do any programming for this, just configure the
> subscription
> 3) sure. Perhaps you might want to configure the ExchangeType 2
(which is
> Download Only) to only the transactions which occurred on the
publisher flow
> to the subscriber. Right click on the merge agent, select agent
properties,
> Steps, Run Agent, Edit, and at the end of the command section hit
space, and
> then type -ExchangeType 2
> Then accept all defaults and restart your agent.
> 4) No.
> 5) use the concurrent snapshot option
> 6) No, use the encrypted file system for this.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html

> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com