<div>
Hope this help you out on setting Snapshot to FTP directory.<br />
<br />
<a href="http://technet.microsoft.com/en-us/library/ms151844.aspx" rel="ugc nofollow">http://technet.microsoft.com/en-us/library/ms151844.aspx</a>
</div>


Hope this help you out on setting Snapshot to FTP directory.

http://technet.microsoft.com/en-us/library/ms151844.aspx [http://technet.microsoft.com/en-us/library/ms151844.aspx]

<div>
rrjegan17,<br />
the link refers to how to add the ftp when using the one of the windows server that hosts the db, what I need is on remote ftp not the one hosting the db server. 
</div>


rrjegan17,
the link refers to how to add the ftp when using the one of the windows server that hosts the db, what I need is on remote ftp not the one hosting the db server.

<div>
In order to use an FTP server for Snapshot folder, you need to configure it from Windows server that hosts DB and not on the Remote FTP server.<br />
Can you kindly clarify your exact requirements.
</div>


In order to use an FTP server for Snapshot folder, you need to configure it from Windows server that hosts DB and not on the Remote FTP server.
Can you kindly clarify your exact requirements.

<div>
rrjegan17<br />
<br />
that is exactly what I want to avoid as indicated in the problem. I think jmoss111 already provided a link for what I need, trying it.
</div>


rrjegan17

that is exactly what I want to avoid as indicated in the problem. I think jmoss111 already provided a link for what I need, trying it.

<div>
Ok, if that works, kindly post your solution here so that it can be useful for others later on..
</div>


Ok, if that works, kindly post your solution here so that it can be useful for others later on..

<div>
TSB, glad this worked out for you; I use variations of these scripts extensively.<br />
<br />
Best Regards,<br />
<br />
Jim
</div>


TSB, glad this worked out for you; I use variations of these scripts extensively.

Best Regards,

Jim

<div>
<div class="content wysiwyg-content">
I need to store the snapshot of a merge replication on a remote ftp, but under the publication's page of Snapshot , I can find only a 'put files in the follwoing folder'<br />
no way to upload this to an ftp server that is remote?
</div>
</div>


I need to store the snapshot of a merge replication on a remote ftp, but under the publication's page of Snapshot , I can find only a 'put files in the follwoing folder'
no way to upload this to an ftp server that is remote?

Using Remote FTP Server for Snapshot

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.