What are the challenges you face when working across database platforms? Take the survey
Options

Log Shipping With FTP

bazzabazza Posts: 2
edited January 22, 2007 8:41AM in SQL Backup Previous Versions
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

Comments

  • Options
    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.
    Chris
Sign In or Register to comment.