Tuesday, February 21, 2012

replication--alternate snapshot location folder-- question

Hello.
I am needing to setup replication for some
pretty big tables. My distributor has
limited space on it. I was wondering if I
can redirect the snapshot location folder
using the options under properties. Answer
is yes, but my question is once the snap
shot has been done and moved over to the
subsriber, is this data then removed from
the original snapshot location? Does it
need to get back to this directory at a
later time for any part of syncing? Or is
it once the snapshot is done and has been
applied, I can go remove that snapshot
location without worries?
Thanks,
I just checked this for you - copying then deleting the original snapshot
files before running the merge agent, and synchronization worked without any
issues.
Regards,
Paul Ibison
|||In article <#sYdrSAfEHA.396
@.TK2MSFTNGP12.phx.gbl>,
Paul.Ibison@.Pygmalion.Com says...
> I just checked this for you - copying then deleting the original snapshot
> files before running the merge agent, and synchronization worked without any
> issues.
> Regards,
> Paul Ibison
>
>
yes, i was able to do this as well. Thanks
for looking at this.. i actually had really
good luck this weekend with using an
alternate snapshot location. One thing I
noticed is that you have to stage the
snapshot agents out a little bit. i was
running too many at once and it would cause
some problems.
thanks,
comb

No comments:

Post a Comment