Slashdot Mirror
Backing Up Laptops In a Small Business?
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?"
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.
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! 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.
Visit Jonesblog and say hello.
Maybe you should be worrying about all your customers data floating around random laptops...
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.
I have found USB external hard drives to be excellent for the purpose of backing up data from either a laptop or desktop. There are also external hard drives sold as one-touch backup solutions as well. Make sure the data is encrypted or the hard drive is physically locked up, because an external hard drive is easy to swipe!
Some posters already mentioned storing data on a fileserver that's backed up (synchronisation or otherwise). I do have to stress one point about that: Laptops are easy to lose and easily stolen, so whatever touches the disk of said laptop, ENCRYPT IT.
I would be just as concerned with this other matter.
How are you protecting sensitive data on the laptop if its stolen?
WhatMeWorry!
I'm not sure what business you're in, but whenever you start storing customer database on laptops, you've got a potential security risk. I work in Healthcare and whenever a laptop or tape with hundreds of thousands of patient names gets stolen, bad things happen. The hospital involved typically has to send out mailings to everyone potentially impacted, which can get extremely expensive and damage their reputation.
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.
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.
Quo usque tandem abutere, Nimbus, patientia nostra?
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?"
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.
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.
After all, I am strangely colored.
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.
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.
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).
so it's dd with a GUI and you're paying for it...?
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.
Visit Jonesblog and say hello.