RE: Snapshot - how often?

David,
syncing is very different to initializing/reinitializing. Once your laptops
have all initialized, I'd disable the snapshot agent (or delete the
schedule). If a new article is added or if a subscriber needs reinitializing,
I want to know about it so then run the snapshot agent manually.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

.

Relevant Pages

  • Re: Snapshot Creation
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... The Microsoft AD account under which the Snapshot agent (and other ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot Creation
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... the snapshot agent properties with the password for the publisher? ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot Creation
    ... The Microsoft AD account under which the Snapshot agent (and other ... I have since moved the AD account around some more between User, Power User, ... Looking for a SQL Server replication book? ... SQL Server Scheduled Job 'Replication agents checkup' ...
    (microsoft.public.sqlserver.replication)
  • Re: Transformable v. regular subscriptions
    ... I have an extra timestamp column in each of the subscriber tables, ... snapshot agent to export the NULL values for inserting into those extra ... Looking for a SQL Server replication book? ... in respect of transferring the exact copy of published data to the ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot Creation
    ... snapshot agent properties with the password for the publisher? ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... There are red circles with white Xs in EM on Replication Monitor, ...
    (microsoft.public.sqlserver.replication)