Back up SQL db to another server

I'm trying to find the simplest solution to run an automated back up of all sql databases on server 1 in site 1 to a network share on server 2 in site 2.

Server 1 is using SQL 2008 on a Server 2008 R2 machine, this is physical.  Server 2 is a file server running Server 2008 R2 and is also a physical box.

Thanks,
JAM-TechAsked:
Who is Participating?
 
jprlopesConnect With a Mentor Commented:
Use this little program:

http://sqlbackupandftp.com/
0
 
JAM-TechAuthor Commented:
Had a look at this but I have no budget to speak of, is there a free way of doing this for multiple databases (probably around 8).

Thanks,
0
 
ZberteocConnect With a Mentor Commented:
Try with SSIS and build a package that will backup the databases somewhere on a folder and then with an  FTP task you move them on the remote location. If you have an enterprise version you can also compress the backup, if not you can zip it but there is no guarantee that will actually be shrunk.
0
 
nemws1Connect With a Mentor Database AdministratorCommented:
How fast is the bandwidth between sites 1 and 2?  Can you mount the drives from site 2 on your site 1 servers and backup to the share?
0
 
jprlopesConnect With a Mentor Commented:
You can still try Sqlbackupandftp for 30 days, without limitations of number of Databases.
And the version you need cost only $52, dont need the more expensive.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.