Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • 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
 
nemws1Commented:
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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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