Backup over internet

frios · September 24, 2008 4:40PM

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 · September 24, 2008 10:10PM

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 = &#91;\\remote\backups\&lt;AUTO&gt;&#93;" '

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 · September 25, 2008 10:00AM

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 · September 25, 2008 12:37PM

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.

Backup over internet

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk