Improve company productivity with a Business Account.Sign Up

x
?
Solved

How to copy the backup of a database to another server / website

Posted on 2011-03-25
5
Medium Priority
?
272 Views
Last Modified: 2012-05-11
My client server application and the SQL server database is deployed in a remote location.
The SQL server database is backed up and is stored in the same server. But how can we copy this backup to another location. Can I copy it on to another computer on there network or can I use like a Webservice call and have the ackup copied onto the Datacenter in my headquarters. The backup file is about 500MB. Or is there any service available that I can plug in to copy the file off nightly.

Please suggest thanks
0
Comment
Question by:TrialUser
5 Comments
 
LVL 3

Accepted Solution

by:
KsLIVER earned 1000 total points
ID: 35214431
What is your goal for the backup location - Off-site or Just replicated to another server?

In the end, you can copy that backed up database to any media and move it where ever.  I use a .vbs file to do copies to an in-house backup server, which then dumps to tape.  If you're looking for off-site and don't want to be using tapes, as long as there's enough bandwidth I'm sure you can upload to any online backup server you prefer.

0
 

Author Comment

by:TrialUser
ID: 35214616
all this has to be done automatically every night. The goal is if my server blows up I have somewhere to go and get atleast the previous days data.
could you please explain "you can upload to any online backupserver" ?
0
 
LVL 9

Assisted Solution

by:kaminda
kaminda earned 500 total points
ID: 35214648
Do you have access to the SQL Server Management Studio, then you can schedule a back using Maintainance Plan Wizard under Management in the object explorer. This is the easiest and reliable way to schedule your backups.
0
 
LVL 3

Assisted Solution

by:KsLIVER
KsLIVER earned 1000 total points
ID: 35214798
If you have the exported / backed-up database file (.bak), you can put it anywhere you want.  If it doesn't need to be off-site, maybe an external drive.  You can then use a batch file, vbs file, or NTbackup and schedule a copy of the database .bak file to it.

kamanda:  He mentioned that it is backing up the db, but just local at this point.
0
 
LVL 21

Assisted Solution

by:mastoo
mastoo earned 500 total points
ID: 35216206
Sql 2008 lets you compress backups, which will help if you are copying this over a WAN.  To elaborate on the above a little, you can have a sql agent job run, make a backup, and copy the backup elsewhere; or you can have a vbs script or similar connect to the server, make a backup, and do the copy.  Security things might interfere with either of these but you'll need to give more details.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In order to have all security and back ups taken care of, WordPress users can sign up for services with WP Engine.
The purpose of this video is to demonstrate how to set up the WordPress backend so that each page automatically generates a Mailchimp signup form in the sidebar. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

608 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