SQL Backup Pro Version for Remote Log shipping?
essamughal
Posts: 35
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
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
Comments
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.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8