Solved

How to automatically store differential backup on another server

Posted on 2014-01-21
9
217 Views
Last Modified: 2014-04-04
Good morning,

My SQL server has two types of backup plans running against it.  I do a full backup nightly , which gets copied to other servers via scripts.  I also have Differentials that runs hourly from 9 to 6 PM. I can't use a script because the files are named different each time.  Does anyone have any recommendation on how to automatically copy/move the diff file to another server?  Thanks in advance.
0
Comment
Question by:tips54
9 Comments
 
LVL 9

Expert Comment

by:Ahmed786
ID: 39796857
You can modify the script to move the contain of the differential backup folder to network server to which you want.

i.e after your differential backup is completed simply the script should be activated from schduled task so that it can move the files contained in the folder where it has been kept
0
 

Author Comment

by:tips54
ID: 39797002
Each file names is different.  do you have an example?
0
 
LVL 9

Accepted Solution

by:
Ahmed786 earned 255 total points
ID: 39797204
Brother, i told you to modify the script in such a way that it will take all the files under specific folder were differential backup is been kept.

So it should not concern about the filename, whtever be the filename.
0
 
LVL 69

Expert Comment

by:ScottPletcher
ID: 39797422
You can use a script with a generic file name(s).  Here's a possible example with a DOS-style MOVE command; there are many other script-style commands to do this as well, of course.

move "x:\local\drive\and\path\to\diff\backups\*.dif" "\\networkdrive\share\*.dif"
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 3

Expert Comment

by:SandyWalve
ID: 39797440
Considering your SQL Server and Remote Location Server is in same domain and your SQL account have access on the remote server enough to store files (Mostly Local Admin) you can use below

http://blogs.msdn.com/b/sqlserverfaq/archive/2009/02/27/how-to-backup-sql-server-databases-to-a-mapped-drive.aspx
0
 

Author Comment

by:tips54
ID: 39797829
Sandy, I had found that article for some reason it does not work.
0
 
LVL 35

Expert Comment

by:David Todd
ID: 39797877
Hi,

I use Ola Hallengren's script
http://ola.hallengren.com/

It can do dif backups and copy only backups.

By separating the different types of backups into their own folders, it makes much of what you are trying to do a lot easier.

HTH
  David
0
 

Author Comment

by:tips54
ID: 39815302
I ended up using Robocopy
0
 

Author Closing Comment

by:tips54
ID: 39979094
thanks.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

929 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

7 Experts available now in Live!

Get 1:1 Help Now