SQLTeam.com | Weblogs | Forums

How to scheduled backup to another location(outside office) on SQL Server 2008

sql2008

#1

hello there,

thanks for coming to my Topic,

i need help about how to put my scheduled SQL backup(.bak) file into other location on internet?

if u guys has reference site about it,let me know. Or please explain here,what i should to do and is there any third application to helps.

thanks alot


#2

I would strongly advise making a backup to a local file, and then "copying" or "moving" that file to the external location.

We use a Cloud Backup and that (basically) copies any file in a given folder to the Cloud

We also use ROBOCOPY to copy Backup files to another location (within the building) so that we have an immediate (safer) duplicate as soon as the backup completes.