Solved

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

Posted on 2011-03-25
5
255 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 250 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 125 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 250 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 125 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
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…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now