• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

How to automatically store differential backup on another server

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.
1 Solution
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
tips54Author Commented:
Each file names is different.  do you have an example?
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.
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

Scott PletcherSenior DBACommented:
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"
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

tips54Author Commented:
Sandy, I had found that article for some reason it does not work.
David ToddSenior DBACommented:

I use Ola Hallengren's script

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.

tips54Author Commented:
I ended up using Robocopy
tips54Author Commented:
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

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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