Backup over internet

frios

Is it possible to backup a SQL database's log file over the internet to a remote server using this product? If so, can someone describe how this is done? I am trying to decide if this is the product for me.

petey

Technically, you can. The destination folder needs to be a network share accessible by the SQL Backup Agent service startup account. Run a backup as you normally would to a network share e.g.

EXEC master..sqlbackup '-sql "BACKUP LOG pubs TO DISK = [\\remote\backups\<AUTO>]" '

However, I wouldn't recommend doing due to network stability issues. What I would suggest doing is to back up to a local disk first, then use the CopyTool or FtpTool utilities to transfer the files over to the remote server. See here for details on those 2 utilities. In this way, a backup is always made, and the files will eventually be transferred to the remote share if the network is stable.

frios

Thanks for the response. I do already make a local backup. I am looking for a way to make an additional backup on a remote device.

Your description below seems to indicate that the machine would have to have some sort of VPN connection to the remote backup destination. Is that correct?

petey

A VPN would allow you to get into a remote network, and map to one or more network shares on that remote network securely. This would then allow you to back up or copy the files to the network share.

If you use FTPTool, you need to be able to reach the remote machine via FTP, which requires the machine to be running a FTP server.