Alternate snapshot location for merge replication subscriber

Hi,
I'm trying to set up a subscriber for merge replication over https. The
initial snapshot file is about 50 Gigs and I'm wondering if its
possible to download & store this snapshot somewhere other than on my
database drive (I have size contraints). Any ideas or direction?
Thanks,
JC
Hi
Yes this feature is available for merge replication, there is some more
information here about alternate snapshot locations.
http://msdn.microsoft.com/library/de...limpl_3vcj.asp
Nabila Lacey
<jbzcooper@.gmail.com> wrote in message
news:1139947715.833574.258470@.g47g2000cwa.googlegr oups.com...
> Hi,
> I'm trying to set up a subscriber for merge replication over https. The
> initial snapshot file is about 50 Gigs and I'm wondering if its
> possible to download & store this snapshot somewhere other than on my
> database drive (I have size contraints). Any ideas or direction?
> Thanks,
> JC
>
|||As well as Nabila's advice, you might want to consider using winzip 9.0 or
winrar to speed up the data transfer. Compression is available in SQL Server
but is limited to the 2GB limitation of a CAB file.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thank you both. I suppose I should have been more clear. I have no
control over the publication itself and thus cannot specify an
alternate location on the publisher. I was told that the drive I was
replicating to needed at least 100GB free to house both the snapshot
and the database it would be loaded into. Is it possible for me to zip
and download the snapshot to my subscriber (assuming they will let me)
on an alternate drive and point my subscription to that?
I do appreciate the help,
Jeremiah
|||Jeremiah,
the alternative snapshot location I was referring to is basically a
subscriber setting. the method you propose is exactly what I have done in
the past for large publications.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Alter Columns for Replication

I want to programmatically change the IDENTITY cols in my subscriber tables to NOT FOR REPLICATION. I want to use SQL code for this since there are many tables and cols and I want to be able to reverse the process.
I can't get the ALTER TABLE ALTER COLUMN syntax correct - it seems that I can't use this command to change the IDENTITY props, only field type, width, etc. Similarly I don't see any stored procs that do this. Can anyone provide the correct syntax or anoth
er solution?
TIA, P
Perry,
unfortunately this is not possible. EM makes it see that it is possible, but
behind the scenes it copies the contents of the table into a temporary table
with the required attribute then renames the table.
Regards,
Paul Ibison
|||Drat. I thought that might be the case.
Thanks for the help.
Perry
-- Paul Ibison wrote: --
Perry,
unfortunately this is not possible. EM makes it see that it is possible, but
behind the scenes it copies the contents of the table into a temporary table
with the required attribute then renames the table.
Regards,
Paul Ibison
|||Perry,
I've just thought of something - I seem to remember that Hilary has posted
up a backdoor method of doing this by editing the system table directly. I
can't vouch for this as I haven't used it, but you'll find it in one of
Hilary's posts. If you can't find it then please post up a message directly
for Hilary.
HTH,
Paul Ibison
|||try this. this is for a single table
http://groups.google.com/groups?hl=e...TNGP12.phx.gbl
this is for all tables
http://groups.google.com/groups?hl=e... NGP12.phx.gbl
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Perry Graham" <anonymous@.discussions.microsoft.com> wrote in message
news:4419796F-4968-4BAB-8B0E-12C104BDAE72@.microsoft.com...
> I want to programmatically change the IDENTITY cols in my subscriber
tables to NOT FOR REPLICATION. I want to use SQL code for this since there
are many tables and cols and I want to be able to reverse the process.
> I can't get the ALTER TABLE ALTER COLUMN syntax correct - it seems that I
can't use this command to change the IDENTITY props, only field type, width,
etc. Similarly I don't see any stored procs that do this. Can anyone provide
the correct syntax or another solution?
> TIA, P