Log Shipping With FTP

bazza

I believe SQL Backup 4 currently requires a shared network drive for log shipping to work correctly. Is it possible to throw FTP into the mix to get it to work for servers that are not on the same network? Is this planned for a future version of SQL Backup?

Thank you,

Barry

Chris Auckland

Hi Barry,

Sorry for the delay in this response.

Currently there is no method to incorporate ftp transfer of data using the SQL backup extended stored procedures.

However some people have configured log shipping via ftp, but they have used a third party solution to copy the data from one server to another.

You could use SQL Backup on the Primary server to backup the database locally, then use COPYTO to copy the file to a location where the ftp can send the file. On the Restore side, the job would be configured to monitor the location that the file is sent to, and then restore from there and copy the file to a processed directory.

There are no current plans to introduce a complete ftp solution for log shipping into SQL Backup.

I hope this is helpful.