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

SQL Backup Pro Version for Remote Log shipping?

essamughalessamughal Posts: 35
edited November 11, 2006 7:51AM in SQL Backup Previous Versions
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

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.