Groups | Blog | Home
all groups > sql server replication > august 2004 >

sql server replication : replication--alternate snapshot location folder-- question



Combfilter
8/6/2004 2:33:56 PM
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?

Paul Ibison
8/6/2004 11:32:42 PM
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

Combfilter
8/9/2004 12:24:52 PM
In article <#sYdrSAfEHA.396
@TK2MSFTNGP12.phx.gbl>,
Paul.Ibison@Pygmalion.Com says...
[quoted text, click to view]
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,

AddThis Social Bookmark Button