Solved

Back up SQL db to another server

Posted on 2013-05-30
5
213 Views
Last Modified: 2016-02-11
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
Comment
Question by:JAM-Tech
5 Comments
 
LVL 4

Accepted Solution

by:
jprlopes earned 250 total points
ID: 39209087
Use this little program:

http://sqlbackupandftp.com/
0
 

Author Comment

by:JAM-Tech
ID: 39209205
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
 
LVL 26

Assisted Solution

by:Zberteoc
Zberteoc earned 230 total points
ID: 39209296
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
 
LVL 23

Assisted Solution

by:nemws1
nemws1 earned 20 total points
ID: 39209391
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
 
LVL 4

Assisted Solution

by:jprlopes
jprlopes earned 250 total points
ID: 39209529
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql query 8 50
Help  needed 3 25
SQL Server 2012 r2 Make faster Temp Table 17 105
SQL Server 2012 rs - Field1 and Field2 add 1 to Total 4 18
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question