[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

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,
0
JAM-Tech
Asked:
JAM-Tech
4 Solutions
 
jprlopesCommented:
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
 
ZberteocCommented:
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
 
nemws1Database 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
 
jprlopesCommented:
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now