Re: Compressed Snapshot Files!!!

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 11:09:11 -0400

use the -AltSnapshotFolder switch on your distribution agent. make sure you
uncheck the generate snapshot in the default folder location for your
snapshot properties. 

-- 
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Naveed" <nrehman@marsonssoft.com> wrote in message
news:eUFealtqEHA.376@TK2MSFTNGP14.phx.gbl...
>
> Hello Hilary!!!
>
> Thanks for your reply, You gave solution for Pull Subscription But We are
> using Push Subscription and we have very slow connection for publishing
data
> on subscriber, i.e why we compress snapshot file in alternate location and
> now we want to configure it on subscriber.
>
> How to do that???
> Thanks,
> Naveed.
>
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:eQGmKXtqEHA.3416@TK2MSFTNGP15.phx.gbl...
> > the snapshot files will be compressed in the cab format in your
alternate
> > snapshot folder. If you are doing a pull subscription you have the
option
> to
> > applying the snapshot (compressed or uncompressed) from an alternate
> > location by using the "Use snapshot files from the following folder
> option."
> >
> > You will have to prove a path to the root of the snapshot location, ie
> > \\PublisherServerName\Share\ where this will map to c:\temp or wherever
> you
> > place your files in. If you copy these files locally you have to copy
the
> > directory structure from unc on, ie if you place the files in c:\temp
you
> > would copy the contents of unc to c:\temp.
> >
> >
> >
> > -- 
> > Hilary Cotter
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> >
> > "Naveed" <nrehman@marsonssoft.com> wrote in message
> > news:OoosGusqEHA.2732@TK2MSFTNGP09.phx.gbl...
> > > Hello All,
> > >
> > > I'm using Transactional Replication. I have compress snapshot file now
I
> > > want to configure it on Subscriber.
> > > I saw BOL and it says,
> > > 1.   In Microsoft SQL Server Enterprise Manager, expand the
subscription
> > > database and the Subscriptions directory, right-      click a
> > subscription,
> > > and then click Properties.
> > >
> > > but didnt find the Subscription directory under subscription database.
> > >
> > > How can I configure???
> > >
> > > Thanks in advance.
> > > Naveed.
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Initial Snapshot not available for Transactional Replication
    ... them using grant statements in a post snapshot script. ... resynchronizing the subscription this has any effect on permissions. ... "Hilary Cotter" wrote: ... On the snapshop Agent the ...
    (microsoft.public.sqlserver.replication)
  • Re: Log wont Truncate when Publication is created
    ... deleted the publication, I first deleted the subscription. ... recreating the snapshot publication. ... database is almost completely rebuilt with each update, ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot agent doesnt pick new articles
    ... subscription for a single article when the publication is configured to use ... subscription without the new article). ... snapshot agent should generate snapshot for the new article after that. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot agent doesnt pick new articles
    ... Even that you specify 'ALL' in the articles to subscribe, ... Then try running the snapshot agent. ... this as it doesn't make sense to create a separate publication when I want to ... If you have a pull subscription you have to issue a call to ...
    (microsoft.public.sqlserver.replication)
  • Re: Appling commands post snapshot application
    ... Added a jobstep to the snapshot agent to create a zipped file filled with> the current snapshot files. ... The resubscribe process copies the zip file, unzips it and applies the> scripts in much the same way the distribution agent does using osql and bcp. ... > This is almost working except I have to wait until the> MSreplication_subscription is created and this does not seem to happen as> soon as the subscription was added. ... >> Then its a matter of manually getting both databases in sync. ...
    (microsoft.public.sqlserver.replication)