Wednesday, March 28, 2012

How often do you snapshot?

Say you want to set up transactional replication from an OLTP server
to a report server. On initiation, it does a snapshot (or we do it
manually), then we replicate in almost-realtime.
Just as an operational matter, what is the best practice here, do
people schedule a new snapshot once a day/week/month/year, just for
good luck?
Thanks.
Josh
The snapshot is only generated at initialization, and on demand or when you
get an subscription that needs reinitialization.
So the default, which I think might be weekly should be sufficient for you.
When the snapshot agent runs it checks to see if any subscribers need a new
snapshot and if do it generates it. If not, it quits and gives an
informational message saying - no subscriptions needed initialization.
"jxstern" <jxstern@.nowhere.com> wrote in message
news:0d3ip01nlrqloo0rsl2nccuq8tm2k0v6a6@.4ax.com...
> Say you want to set up transactional replication from an OLTP server
> to a report server. On initiation, it does a snapshot (or we do it
> manually), then we replicate in almost-realtime.
> Just as an operational matter, what is the best practice here, do
> people schedule a new snapshot once a day/week/month/year, just for
> good luck?
> Thanks.
> Josh
>

No comments:

Post a Comment