

Backing Up Laptops In a Small Business? 293
Bithmus writes "I have been tasked with finding a way for our company to handle our laptop backups. We currently have nightly backups of our servers, but no backups of laptops. In our business we develop, implement, and sell another company's software; I guess that makes us a Valued Added Reseller. During development our consultants will create copies of a customer's database on MSDE on their laptops. If a hard drive crashes, all of the work done on that laptop is lost. There are other files that need to be saved, but the databases are really the important items. Ideally these databases would be stored on the SQL servers and the other files stored on the file server, but this is not happening. What do Slashdot readers do to protect data on laptops or computers outside of a local network?"
File synchronization... If you must... (Score:5, Insightful)
For a small business? Probably simple file synchronization. Right-click on a network drive and pick "Make Available Offline." You'll still have to train people to store their shtuff on the network, but at least that way they'll have access to it even if they're not on the network.
Of course, you might run into some issues with files being locked and such, but you're probably going to have that anyway unless you go with either a big expensive solution or you just get people to use SQL server databases instead.
However, just because it needs to be said...
The first time that someone loses a million dollars' worth of data or one of your consultant's laptops (with customer data) gets stolen, it will start happening. I don't have much sympathy for this kind of thing. I mean, it's kind of like saying, "Ideally, the money in the bank should be behind the counters with the tellers instead of just laying around in the lobby, but this is not happening." Make it happen. If you can't, at least make your management aware of the risks they're facing so that when something horrible happens, you've got a nice paper trail showing that you're not the scapegoat they're looking for.
If you were a big company, you could probably buy something expensive to mitigate the risk, but it still wouldn't be a good idea. At my big company, we use Connected DataProtector, and I hate it. Once a day, it runs a backup of my laptop and everything on my machine comes to a grinding halt for five to ten minutes. Oh, and it doesn't back up files in use (you know, like MSDE files under development), so a lot of stuff doesn't get backed up anyway.
Re:File synchronization... If you must... (Score:5, Insightful)
This is the right idea, but I smell a major WTF at this company. It sounds like the developers aren't using version control. They really just need to set up a repository for each project (SVN is my default recommendation, but something with better support for binary files would be useful here) and just back up the repositories.
Re: (Score:2)
Re:File synchronization... If you must... (Score:5, Insightful)
Parent is 100% bang-on. Years ago, as a well-intentioned, bright (but organizationally naive) systems analyst/engineer, I did not do enough to document systems design risks. This was partly because I was simply too confident in my abilities.
Today, I'm careful to report on certain aspects of system functionality that are key development objectives--and what business risks are tied to those objectives not being met. Sometimes, a business has to make the hard choice of willingly flying by the seat of their pants, but a good consultant or employee is there to make the consequences of all choices clear to the management. It's more than just CYA.
If it's logistically possible, a VPN running over a Verizon, Sprint or AT&T Wireless data service may be what's needed. Perhaps it maintains a real-time connection to the back-end or perhaps it backs up periodically. In any event, it would reduce the "exposure window" of damage, i.e., if this laptop is stolen in the next four hours, I know the data was backed up at least once in the previous four hours.
The cost of wireless data cards and service is plummeting: this may be a good time to consider it.
Re: (Score:2)
Yeccch.
Re: (Score:2)
They are techincally stored in a fashion similar to this (not really, they are split up so directory sizes don't grow too huge) but they appear in their normal folder trees. (you access them exactly as you would if you were network connected)
Why post flat out deceptive comments?
Re: (Score:3, Informative)
I will say that on XP the offline files feature is not very stable when used with large data sets and does not attempt to do
Re: (Score:2)
2 wrongs don't make a right (and before someone thinks they are witty.... 3 lefts yadda yadda yadda)
Re: (Score:2)
But let's get back on topic. If it's not a really a chronological backup that's needed, then maybe https://www.foldershare.com/ [foldershare.com] could be a possible solution to the problem.
It synchronizes user-specifyable folders amongst multiple machines in a real-time fashion, so this might work well if those roadwarriors also have a desktop in the office they could synchro
Re: (Score:2)
Errr, no you don't?
My work laptop has it's My Documents folder pointing at a network drive which is offlined. When I connect to the vpn or the work network, I can synchronize it fairly quickly. The central file server is backed up to tape every day. If I break my laptop, I get a new one, whack a standard image on, and my files are all still there. If I delete the remote copy (because I'm stupid), I just request yesterdays tape be restored for me.
Works great. Folders and all.
Re: (Score:2)
Re: (Score:2, Interesting)
First, File synchronization is the easy way to go. I would avoid using the off-line files feature of Windows xp. I've had lots of problems with it. First of all, if the network connection drops for any reason then the user ends up off-line and can't print. Depending on how savvy your users are this can be a problem. I suggest SyncToy from Microsoft or another third party solution.
On the security side, we have Lenovo Thinkpads. With the embedded sec
Re: (Score:2)
Incremental backup via secure VPN via internet - IMHO the best option - should be easy to arrange. What do you do for your main off-site backups? Do you have a ser
UMTS+VPN+RDP (Score:2)
I use Citrix to work from my laptop and have a 3G card that sustains about 500Kb/s data, which is plenty for that. If the laptop is dropped/stolen/run over/burned, I've only lost hardware and can just wander over to any machine with web access--and often don't even need to install any client software. Setting up a standard VPN+RDP solution is pretty simple and a lot cheaper (read: essentially free).
Besides, it is not an entirely bad idea to nail into people's heads that their laptops should essentially be b
Re: (Score:2)
A solution is not a solution if it doesn't get used. We have only 5 guys with laptops, but some are smart enough that they can cause trouble. I was using a network backup to tape drive, but these guys could go into their Windows task manager and kill the process, 'cause they didn't like the way the backups bogged down their performance. Since I had a solution in place, my ass was covered,
Re: (Score:2)
At my big company, we use Connected DataProtector, and I hate it. Once a day, it runs a backup of my laptop and everything on my machine comes to a grinding halt for five to ten minutes. Oh, and it doesn't back up files in use (you know, like MSDE files under development), so a lot of stuff doesn't get backed up anyway.
At *my* big company, we also use Connected DataProtector, and I love it. I set the schedule [googlepages.com] to back up automatically on week-days between 12:30 and 1:00, when I'm at lunch and won't notice any slowdown. If for some reason I miss a backup for five days in a row (say, if I'm working at a client site with stiff SOX or HIPAA enforcement), it will nag me as soon as I connect to the Internet over anything faster than a modem. And finally, it asks me for permission before the backup begins, allowing the optio
Re: (Score:2)
Re:File synchronization... If you must... (Score:5, Insightful)
BackupPC keeps track of a device's ping history. If the device only comes in during the day, after a couple of days the system will start backing it up as soon as it connects to the network.
I use it to back up the LAN, portables, and PCs connecting via VPN -- given that it can back up via RSYNC, SSH and SAMBA, pretty much anything with a HD connected to the network gets put into the system.
The backups are also mirrored for off-site storage so there's always an in-house revision system and an emergency remote restore point. The system works well, and for small businesses can easily store 1.5TB of data on a single 250MB HDD (make sure to mirror).
Re:File synchronization... If you must... (Score:4, Funny)
Really? That's some AMAZING compression. Still, where would you find a 250MB hard drive these days?
Re: (Score:2)
Lots of Carbon Paper (Score:4, Funny)
Re:File synchronization... If you must... (Score:4, Funny)
Nice to see it survives to this day.
Re: (Score:2)
1) Export the data first or
2) stop the database engine before backing it up
So, any solution like this needs to have some scripting at the "pre backup" and "post backup" phases so that stopping and starting of the database engine is done. Also, the user will have to be asked if it is OK to stop the database for a backup. Most likely best to just do an online dump of the database and back up the dump so that the user doesn't have to stop w
Re: (Score:2)
Re: (Score:2)
Re: (Score:2, Informative)
Re: (Score:2)
Indeed, BackupPC does some clever tricks when storing (partially) identical files, which they call "pooling". So it's not actually compression (it does that in addition to the pooling, too), but rather the non-storage of redundant information that saves lots of space in the backups.
Re: (Score:2)
Re:Where is BackupPC client for Windows Installer? (Score:2)
Clone 'em (Score:4, Insightful)
For years, I have ordered all of my systems with at least two hard drives. For laptops, I order an additional external drive. Currently, I have a very simple protocol: I use OS X and clone the entire hard drive with operating system to a second hard drive with SuperDuper! [shirt-pocket.com] It is fast, it is easy and if the laptop dies, I can simply boot directly from the backup drive, be back up and running and I don't even have to reinstall applications or set all my preferences. It's like nothing ever happened. By the way, I also use this approach for all my workstations. Disclaimer: I am in no way affiliated with Shirt Pocket software other than being a satisfied customer.
Re:Clone 'em (Score:5, Insightful)
1) Security. If I can steal one of your backup drives, datawise, I just stole the notebook.
2) Efficiency. While I don't know SuperDuper, I assume it clones the entire drive. This seems like a waste of time for a few changed files. An incremental backup would be much faster and more efficient with maybe full backups weekly.
3) Reliability. I assume each backup overwrites the last, correct? If the system crashes while a backup is being made, you just killed the original and your only backup! The odds of it dying during the backup are slim, but it has happened before. You may want to consider getting an external HDD that is 2x the size of your McDrives and split it into two partitions. Only back up to the secondary partition. When the backup is complete, copy the secondary to the primary. If the system crashes while you are copying, you won't be able to boot of the primary, but at least your data will be recoverable.
Still, it is not a bad plan, especially considering the falling cost of IDE HDD's and enclosures... it's certainly more expensive NOT to backup!
Re: (Score:2, Interesting)
Probably overkill but I burn data files on a regular basis to DVD in case you want to go back to a prior saved file that has been deleted from the computer. Then clone the hard drive and use backup software to
Re:Clone 'em (Score:4, Informative)
It is regrettable that SuperDuper doesn't support encrypted backup targets.
FYI, it does do incremental backups, but they can be a bit slower than rsync, mainly because it does a bunch of tests when copying. The main appeal of SuperDuper! is that it copies everything, including alternate data streams on files (a big deal for us OSXers sometimes), extended FS attributes, and files that OS X would otherwise not allow you to, making the backup drive fully blessable and essentially indistinguishable from the original.
I am a happy SuperDuper! user as well, my only gripe is that it lack the encryption and the ability to do "snapshots" of different versions of the filesystem -- though the latter is likely to be addressed by Time Machine.
Re: (Score:2)
There is also *nothing* like the security of knowing that you can easily recover from a disk failure to where you were within a few days. And I have had a hard drive fail (in my PB), and I did use SD to recover.
Retrospect (Score:2)
Thinking about losses made me shake. Thank god for beer...
Re: (Score:2)
dd? (Score:3, Interesting)
Re: (Score:3, Insightful)
Absolutely, yes. Because we have students that rotate through the lab that cannot navigate their way around a CLI initially. To get things done with them, we given 'em GUI apps then migrate them to harder things. Besides, I find SuperDuper! to be actually faster and easier to use with a GUI than with the CLI and I am happy to fairly compensate the authors for their work in increasing my productivity.
Worry about laptops getting stolen! (Score:5, Insightful)
Directly put your customers data on big boxes at the office... let people remote desktop in and work. No longer will you have a backup problem for laptops - nor a security problem.
Mod Parent Up... (Score:3, Insightful)
If you otherwise cannot avoid it, get each laptop user a geek-stick of appropriate size (a couple of GB), format it with an encrypted file system, and make 'em store everything even remotely sensitive on that. The odds are good that no one is going to go out of their way to target and steal a geek-stick at the airport (at least not as much as they'd want your laptop), and you can be reasonably sure that it will survive being dro
Mod parent up (Score:2)
Since we're talking about laptops here, this is THE solution IMO, covers both failure and theft. Granted, off the LAN, it could get a little sluggish, but you know, security, right?
Re: (Score:2)
Well I think my home is better secured than our company's office. I have two dogs in here (weights 40 kg ja 80 kg) both with strong instincts to guard the house. Then I have shotgun in my closet but I don't think there's need to shoot after Osku and Kaapo has dealt with the burglar. What our office has? Burglar alarm and hopefully security firm will be there on time :)
Re: (Score:2)
Better yet, unplug the servers, stop up all the ports with glue, encase the server in lead and seal it up in an abandoned salt mine...
You need to strike a balance between security and usability. If the laptop users need customer data offline, then they have to get it. Encryption solves the security problem. The backup problem could be s
Re: (Score:2)
Telling colleagues their password, writing it down, using the same password with an incrementing number on the end - all these things are commonplace. If the
External USB Hard Drives (Score:2, Insightful)
Write a login script (Score:3, Interesting)
1. Stop the MSDE service, put up a msgbox asking that all other applications be closed.
2. Run a VB Script or some other program of your choosing that copies the files to a location on your network (you can always reconnect old access databases as long as you save the MSDATA directory).
3. When done, restart the MSDE service.
Sure, your consultants will hate it (it'll take a few minutes every time they log on) but it's the only real option.
Several options... (Score:4, Insightful)
not very much (Score:2)
RTFM (Score:2)
I haven't seen much in this area. I use Retrospect for all my computers at work, but laptops are kind of come-and-go. I have 2 backups scheduled every day, and the laptops are lucky if they catch one or two of those per week. And quite honestly, I don't find Retrospect very dependable for that matter,
That's because you don't have it set up correctly. Retrospect is fully capable of doing opportunistic backups. Has been for a little shy of ten years. You set a policy for the max age of the backup, pick
Re: (Score:2)
However, it is sort of aging too. It doesn't do encrypted backups, and this doesn't sound like a big thing, but in these days of HIPPA, SOX, and other corporate regulations, having encrypted backup tapes means a quiet report to the local police about stolen hardware, versus having to report to the press data loss (if in California, and the tapes contain
Use CVS etc. (Score:4, Interesting)
Surely if you are doing any development etc work then you should be storing code/data in CVS or equivalent running on a server.
Remember that source control is not limited to just software. You can use it to store all kinds of stuff (documentation, artwork, video...).
Any business model that depends on critical data in laptops is broken.
Re: (Score:2)
Don't use backups to shore up a broken system (Score:2)
There are two ways to fix this:
1. Fix the server access problem so that people work as intended.
2. Use something like CVS to store back critical data.
Using a laptop backup process to keep a broken system going is silly. Rather fix the system so it does not need backups.
Re: (Score:2)
SyncBack (Score:2, Informative)
http://www.2brightsparks.com/syncback/sbse-featur
I'm happy with it so far. You can configure whatever folders you need backed up, where, when, and it does intelligent checking for whether it actually needs to create backups of files based on any number of file attributes.
Encrypt those drives! (Score:5, Insightful)
We had a case of a vendor that ended up making other customer data (fortunately not ours) available on the Internet to the point where Google was indexing patient billing records. It was sad in a way, the owner had spent a decade building up his business and overnight the company vanished.
Though this isn't the answer to your question, please be cautious with the data on your laptop. Even if you have no medical customers, odds are you work with data that has privacy implications. Treat it with care.
Batch Script (Score:2)
Re: (Score:2)
Realistically its not that hard, just talk to "the boss" about getting the workers to jack their laptops into the lan before lunch (although without a good topology you may rip your networks guts out if some big jobs have just started).
mozy pro (Score:2, Informative)
Retrospect and/or RDP? (Score:3, Informative)
Another idea, if you can configure a VPN, is to put all the MSDE data that the laptop users use on one Windows 2003 machine, and run SQL Server and Terminal Services. Then, you can focus on backups of that machine (Retrospect has a lot of options for keeping SQL Server backed up), and less on worrying about keeping client files copied.
Two options (Score:2)
I have been using BackupPC [sourceforge.net] for some time now with great results. Despite its name, the software is quite powerful and easily fits borderline enterprise requirements. It'll function with most platforms out there, and has some nifty options for laptop users - meaning the intermittently connected machines.
I have also used Symantec's BackupExec with the Desktop and Laptop Option (DLO) [symantec.com] with mixed results. It fits the bill if you're running a homogeneous network.
I wish you good luck. Having fully backe
Mozy (Score:4, Informative)
www.mozy.com
You should check them out. I've been very happy with them.
Re:Mozy -- too bad it is unreliable (Score:2)
Re: (Score:2)
In general their restore process blows, but I still recommend them because once you figure it out the first time it's not too bad. My clients will be calling me if they actually need to get something back...
-R
cron + rsync (Score:2)
To make things even easier for users to protect data they see as important, I have an icon they can click to sync to the server at any time.
Re: (Score:2)
Unison (Score:2)
I'm currently playing with Unison http://www.cis.upenn.edu/~bcpierce/unison/ [upenn.edu] which does syncing through SSH, it runs on Linux, MacOS X and Windows (on Windows you have to install SSH though) Is runnable from a command line and is configurable from a simple text file describing what directories you want synced and what exceptions there are.
It's very similar to rsync except that it has an added module that keeps a history of the directory contents to properly handle syncing file removals/renames/etc. It i
Sounds like you already have a solution! (Score:2)
Ideally these databases would be stored on the SQL servers and the other files stored on the file server, but this is not happening.
Ok, so why not do that? You just say, "this is not happening," but you don't say why you can't make it happen.
Problems like these tend to depend a bit on the context. The best solution depends on what your needs are. I don't typically have Windows laptops these days-- luckily the laptops at my current company are much more likely to be Macs. So I put an rsync script to c
VALUE-added reseller.. just wow (Score:2)
http://en.wikipedia.org/wiki/Value-added_reseller [wikipedia.org]
Re: (Score:2)
planning for backups by partioning (Score:2, Informative)
I just dup the root with regular Windows Backup, Norton Ghost,
I wore an onion on my belt... (Score:2)
After I improved the performance by a factor of ten by reordering the dimensions, I had enough free time to be 'proactive', finding and providing fixes for things such as everyones payroll being short by
Use what you have. (Score:2)
You have a network. Use it. Briefcase is your friend.
Set up your laptops with a PGP drive to hold all work information. Unless management likes the idea of your work product being stolen and given to a competitor.
Train your users about where to save their data. Then use policies (Windows, not HR) to enforce it.
If they're in the office regularly, use KIX scripts to copy the entire PGP file to the network. Poof, instant b
Re: (Score:2)
Windows Home Server (Score:2)
Re: (Score:2)
Example (Score:2)
If there is enough space on the laptop a duplicate copy of the database is a good first step, then rsync that to head office. You should be checking how often the rsync images are updated and chasing tardy users. This stage can all be scripted, we had reps who would plug in the laptop in the evening and this would run during the night every night.
OK so now you have the data in house and secure.
The next stage is what to do w
Rsync Backup (Score:2, Informative)
cygwin installed for the windows laptops laptops..
the mac laptops already have rsync
you then need to put your rsync command into a script/batch file:
IE:
#!/bin/sh
rsync -avz -e "ssh -i
the second half of this is to do a nightly tar ball of th
Re: (Score:2)
This is a little old, but it worked when I wrote it up.
http://battjt.soliddesign.net/ssnap.html [soliddesign.net]
I'm able to backup my wife's whole XP machine and my OSX home directory every night to the office over a lousy asymmetric cable line. At the same time I back the office up to the house (about a dozen home directories and a w2k machine).
Joe
... Connected TLM ... (Score:2)
mac os x version (Score:2)
Rule #1: Don't backup laptops (Score:2)
Well there's your answer: Make it happen.
Laptops (a) should NOT have critical information stored on them, and (b) should ABSOLUTELY NOT NEVER NO WAY be the only repository for critical information.
rsync (Score:2)
Some things I've looked into... (Score:3, Informative)
First of all, to all you smug pricks who offer comments like "don't keep important data on a laptop" or "your business model is broken" - this ia a real problem for many people. If you don't have a real suggestion then STFU. It should be well understood in a place like Slashdot that not every IT guy gets to set corporate policy. Sometimes you have to work with what you've got.
On the topic of laptop backups, I've been dealing with this issue for years. Here are some thoughts:
For simply backing up a few critical files, consider a USB Flash Drive. I usually write a simple .bat file using xcopy to backup particular files or folders, then create a shortcut with a friendly name for users to double-click on. With a bit of thought you could probably create an autorun.inf file that backs up when the USB stick is inserted. One caution - drive letters may be slightly unpredictable.
For a more thorough backup, clone the entire drive to an external drive. There are many programs that can do this but these days my favourite is Acronis True Image [acronis.com]. Acronis could clone on a schedule if you can train users to connect an external drive overnight, for example. It's always nice to have a complete backup including OS, applications and data. Acronis also lets you browse inside a backup image and extract individual files if needed.
What I've always really wanted was a solution that would detect when a server was reachable and backup transparently. I use something just short of this on my own laptop - product called Mirror Folder [techsoftpl.com] that I schedule to copy specific folders when I'm connected to my home network every night. This could probably work over a VPN as well. Very simple, very cheap.
If you have a larger budget than me you might be interested in something like Atempo LiveBackup [storactive.com].
Tivoli Continuous Data Protection for Files (Score:2)
http://www-306.ibm.com/software/tivoli/products/co ntinuous-data-protection/ [ibm.com]
Backs up to network drives, WebDAV folders, or tivoli storage manager serv
Re: (Score:2)
Simple option... (Score:2)
And usually it's not actually that expensive. A quick 30 seconds search through some suppliers puts the price at somewhere around £10 per laptop or desktop.
Also, usually you'll find that these products feature delta compression/synchronization abilities, same kind of thing as rsync.
DLO? (Score:2)
iFolder (Score:5, Informative)
Check it out: http://www.novell.com/products/ifolder/ [novell.com]
-m
USB drives and batch files (Score:2)
We use "opportunistic" backup (Score:2)
Our server checks every half hour to see if a laptop is on the network. If it finds it, it does rsync-over-ssh to back up the laptop (we use a special SSH key for the purpose.)
Our script also won't back up a given laptop more than once every 8 hours.
This assumes that the laptops run Linux or some kind of UNIX. If you run Windoze, then you'll probably have to look for an expensive inflexible proprietary solution, but you should be used to that by now.
Why does this sound familar? (Score:2)
BackupPC (Score:2)
It has support specifically for laptops.
LiveBackup (Score:2)
LiveBackup [atempo.com] from Atempo [atempo.com] will solve a lot of these problems. You will need a dedicated backup server, preferably with a lot of disk and a tape library/autochanger.
With LiveBackup, as the network clients (the laptops) have changes made, compressed, encrypted block-level changes are sent to the LiveBackup server, and applied to each machine's backup image. Data is de-duplicated on the ser
Sometihng i've tried/like (Score:2)
It can work in a number of ways, but essentially its like a volume replication thing where it continuously replicates the hd itself to another device (usb drive or iscsi drive). Now while your on the laptop outside you can replicate to a partition on the usb drive. In the office you can use something like an iscsi lun to replicate to.
Its not terribly expensive from what i remember for only that capability (like $99/laptop?). If you use iscsi and it cant see the iscsi lun (off
Version Control (Score:2)
Sounds to me like you could gain a lot from setting up a version control system. Run it on a machine other than the one on which primary development takes place, and have your consultants check in their changes. This will not only give you backups, but also a host of features (such as the ability to go back in time or make diffs between versions of files) that, in my experience, are very valuable. Needless to say, it also makes coopera
Real-time backup (for Windows) (Score:2)
Periodic backups are fine for stationary and/or always-on(-and-connected) machines, but not so much for laptops (which may or may not be connected to anything when the backup is due). Alternatively, users would have to remember to occasionally start the
Re: (Score:2)
Re: (Score:2)
Do it unofficially. (Score:2)
When somebody needs a restore, take their box and tell them you'll see what you can 'recover from the drive'. Don't tell anybody what you're actual