Restore selected files using a script from Sugarsync, SpiderOak, Dropbox, Carbonite ... or?

I'm working to set up a backup system with one of the mainstream online backup companies.
So, I'm looking at Sugarsync, SpiderOak, Dropbox and Carbonite.
(Any other suggestions would be appreciated).

One of the things I need to be able to do is to run a Windows batch file that will restore a file (or files) from the online backup.  
And, I need to be able to delete a file (or files) from the online backup.
Well, I guess it wouldn't have to be a batch file but that's what I'm most comfortable with and the task is pretty simple.
In the end it will be part of a process that will run hands-off using a scheduler.

Is that possible?  I don't have much experience with these services.
LVL 27
Fred MarshallPrincipalAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scot HalvorsenCommented:
I am not sure about the others, however DropBox keeps a local directory synced with your files in their care. In most cases it can be found within your home directory identified by variable "HOMEPATH" (Type "set" within any dos box to see all of the default variables.) Any time you add or remove files from this directory (even if it is done on another computer), your computer will be kept up to date.

So a simple script would be able to restore your files any time you wish.

@echo off
set sourcedir=%HOMEPATH%\Dropbox\BackupDir
set destdir=c:\BackupCopy
echo Copying from %sourcedir% to %destdir%
xcopy %sourcedir% %destdir% /i
echo Finished

Open in new window

The variables "sourcedir" and "destdir" can be changed to point to the directories that you wish to copy.
Fred MarshallPrincipalAuthor Commented:
shalvors:  Thanks!  I'd figured that much out myself as I have Dropbox installed.  I'm less familiar with using Dropbox as a backup destination.

I still wonder about the others.  There are quite a few Carbonite instances already and I'd like to be able to be a bit flexible.
Scot HalvorsenCommented:
From what I have read online, Carbonite acts more like a traditional backup solution. Think of it like a cloud tape backup. The client software collects up all files of certain types from your "Users" directories and sends them to their storage facility. If you want something restored, you have to explicitly tell them to send the file back to you.

With this in mind, I don't think that you original requirement to delete or restore files with a batch script would be possible with Carbonite.
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Fred MarshallPrincipalAuthor Commented:
I wonder if it matters which version of Carbonite is being used?  It appears the products vary quite a bit in terms of such capabilities.

The questions remain for SugarSync and SpiderOak (the latter I'd never heard of before....).
Thomas Zucker-ScharffSolution GuideCommented:
I do NOT recommend the vanilla version of dropbox as a backup because it is not a true backup at all.  Spideroak is very good in terms of retention and ease of use with command line options.  I have used spideroak for years and up until several weeks ago would have recommended this as your best option.  I am currently using Crashplan as my backup option.  CrashPlanPROe is an excellent product for business (enterprise version).  We have run it locally (we have a local CP server instead of using their cloud) for a couple of years now.  I switched from spideroak to crashplan at home as well.  I am not as familiar with the command line in CP, but I do know that at work we can monitor and control virtually everything through a graphical interface, including getting various stats.

My article on why I changed from SpiderOak to CrashPlan is here:

I also wrote a basic article on backup here:

I tried sugarsync and didn't like it at all - I don't remember exactly why.  Versioning is key here.  backup without versioning is useless and a robust restore option is necessary.  I believe that CP has the best options.  Moreover, CP will allow users to do their own restores (read less of a headache for you).  Also CP allowed us to easily recover from a cryptowall infection (in less than 2 hours) due to the versioning.
Fred MarshallPrincipalAuthor Commented:
RE: "Using a script"

So far, the list of possibilities that I've gotten here are:

I've also learned that there is a developer's interface with SugarSync that appears to offer a way to automate scripts.
Thomas Zucker-ScharffSolution GuideCommented:
As I said above I really feel dropbox is not true backup. Scripting should be fairly easy with spideroak,  like I said I have experience work the command line in spideroak.  I imagine crashplan has a similar command line interface. Either way I have not seen the kind of versioning support that is needed in dropbox. Also note that the algorithm puts a copy of each file on the source computer, including versioning.
Fred MarshallPrincipalAuthor Commented:
So far now I have found that scripting should be possible with:


But it's not clear if SpiderOak or SugarSync would be dealt with using Windows command prompt scripts /  .bat files??
Thomas Zucker-ScharffSolution GuideCommented:
Spideroak will work fine with batch files. I suggest AutoHotkey as a better alternative though.  I am new to AHK but I have found it to be much better than batch files in most cases.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.