Re: Snapshot - how often?

The default is once a week. If I make an update to a non-filtered column
(we don't use any filters) do I still need to run the snapshot agent before
the subscriber (anonymous) sees the new column?

David

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:eiNdVfFAGHA.740@xxxxxxxxxxxxxxxxxxxxxxx
> The snapshot agent by default IIRC will run every 1 hour, but only
> generate a snapshot when one is required. Snapshots are only required if
> you make schema changes to filtered column using the sp_repladdcolumn or
> sp_repldropcolumn or if you need to reinitialize.
>
> --
> 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
>
> "David" <dlchase@xxxxxxxxxxxxxxx> wrote in message
> news:eWHYaADAGHA.3852@xxxxxxxxxxxxxxxxxxxxxxx
>> We have a Merge replication on SQL 2K with same publisher/distributor and
>> only anonymous (laptop) subscribers. How often is it necessary to create
>> new snapshots when the laptops are synching frequently (every couple
>> days)? Also, is new snapshot needed only if structure changes? As you
>> can tell, I am new to replication. Thanks.
>>
>> David
>>
>
>


.