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.
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.
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.
External USB Hard Drives (Score:2, Insightful)
Several options... (Score:4, Insightful)
What about stolen? (Score:1, Insightful)
How are you protecting sensitive data on the laptop if its stolen?
WhatMeWorry!
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.
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 dropped, kicked, shoved about in luggage, etc.
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:File synchronization... If you must... (Score:1, Insightful)
Yes, exactly. The submitter already knows what the correct solution should be and should be asking "how do I get employees to follow sane backup policies?" not "how do I design a backup solution which can handle hostile users?"
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: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: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:dd? (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.