SQL Backup Pro Version for Remote Log shipping?
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.
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