automating snapshots

I'm new to replication and maybe I'm missing something.
I set up replication from one server to another (push).
The replication is working fine every hour, but I have to start the
snapshots manually.
If I don't, no replication takes place, because there are no changes in the
snapshot.
I want the snapshots to be taken automatically every hour, and then
replicated to the other server.
Is this not the way it works normally? What am I missing?
Riki
It really depends on what type of replication you have set up. If it is
transactional replication, then the snapshot agent runs once to initialize
the subscriber and hten is not normally scheduled to run again - changes to
the publisher's data are sent to the subscriber as transactions rather than
ODBCBCP snapshots. If you have snapshot replication set up, then the snapshot
agent should indeed be set up and scheduled to run - before the distribution
agent. This is not typically done regularly as it'll lock tables on the
publisher and prevent access to the subscriber tables also until the process
completes.
HTH,
Paul Ibison
|||Thanks Paul!
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:D9819EC4-E490-4BDB-A1B2-9EA49E6D1708@.microsoft.com...
> It really depends on what type of replication you have set up. If it is
> transactional replication, then the snapshot agent runs once to initialize
> the subscriber and hten is not normally scheduled to run again - changes
> to
> the publisher's data are sent to the subscriber as transactions rather
> than
> ODBCBCP snapshots. If you have snapshot replication set up, then the
> snapshot
> agent should indeed be set up and scheduled to run - before the
> distribution
> agent. This is not typically done regularly as it'll lock tables on the
> publisher and prevent access to the subscriber tables also until the
> process
> completes.
> HTH,
> Paul Ibison
>