Log Shipping over FTP
RobSchripsema
Posts: 9 Bronze 2
My memory tells me that your SQL Backup tool used to have options for setting up log shipping over FTP (rather than a file share). I no longer see any references to that in your product description. Has that feature been removed in version 7, or am I just not seeing it?
My need, simply put, is to log ship SQL data between a local server and one running on a different domain in a remote, VM environment. We can't set it up to use a UNC path for transferring the transaction log backup files, so we're thinking FTP. I could probably build my own custom mechanism to do this, but would rather use a tried and true method with a tool like SQL Backup. If your tool no longer supports this functionality, can you recommend an alternative?
My need, simply put, is to log ship SQL data between a local server and one running on a different domain in a remote, VM environment. We can't set it up to use a UNC path for transferring the transaction log backup files, so we're thinking FTP. I could probably build my own custom mechanism to do this, but would rather use a tried and true method with a tool like SQL Backup. If your tool no longer supports this functionality, can you recommend an alternative?
Rob Schripsema
Comments
ftp://support.red-gate.com/patches/sql_ ... TPTool.zip
Details of it can be found here:
http://www.sqlbackuprestore.com/usingcopytool.htm
Though it describes the workings of the CopyTool app, most of the details apply to FTPTool too.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8