SQL Backup Pro Version for Remote Log shipping?

essamughal

Hi;

We have been using SQL Backup Standard edition for log shipping to ship log one of the remote server. The way it is implemented right now, is as follows;

1- Used Red-Gate Stored procedure to create log every 15 minutes in a SQL Server job

2- Use FTP client to FTP that log to remote server every 15 minutes

3- Apply that Log on Remote Server every 15 minutes

It is working fine for us, but the FTP client is keeping failing on us very frequent and we are thinking to get Red-Gate Professional version to eliminate FTP Client layer from this process.

Question:

1- I am wondering if Professional version would resolve that problem
2- Would it use VPN or how it will transfer log to remote server

Thanks

petey

SQL Backup uses the Windows file system to copy files, so it's only practical for servers residing on the same LAN, or connected via a reliable WAN.

I would say that the FTP protocol is more reliable over long distances. If you are having problems with FTP, the problem probably lies with the network. Using other protocols wouldn't help.