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.
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'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.
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!
There is no "I disagree" mod for a reason. Flamebait, Troll, and Overrated are not substitutes.
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).
I just have all my users print out all the data from their hard drives, in binary, onto carbon paper. Daily. The costs may be prohibitive for you. But the peace of mind for me is priceless.
Now that I think about it, I'm pretty sure everything I just said is completely wrong.
Novell's iFolder is great for laptops that travel in and out of the office. Has an open-source version as well as a commercial--so management can pick their comfort level. Clients run on Windows, Mac (better support coming soon), and Linux. Setup some automated methods of dumping your MSDE data.
Check it out: http://www.novell.com/products/ifolder/
-m
http://www.invisik.com