Question on backups for a very small business
Here are the things that bring instant concern:
They run on a single 7200k drive each
Well, at least you're backing them up onto the file server and to a DVD. This is a huge point of failure, and from my experience at a printing house thost 7200rpm disks are going to be worked hard (this was 10 years ago and they were printing 700Mb TIFFs generated by drum scanners - I don't know how much has changed since then) and the harder a drive is worked the earlier it will fail.
If it's possible, get some RAID1 onto those disks. If they're running any flavour of Windows Server (2000 or newer), XP Professional or any version of *nix you can add software RAID without needing to spend any money on anything except an additional hard drive.
I thought of proposing that they at least buy two 1 TB USB drives and alternate them by having one person take them home and then bring back in to keep a copy offsite.
This is actually a pretty good scenario if you're on a tight budget. I don't know what $200 buys where you're from (the price for those sorts of things in Australia is almost criminal and you'd struggle to get two 1Tb USB drives for < $200) but that's going to be miles ahead of what you've got.
You don't even need any special software for what you're proposing. Download a version of RoboCopy (the Server 2003 tools will have a version that will work on Server 2000, version XP010). Then a scheduled task that runs:
robocopy e: f: /mir (where e: is your source, f: is the removable disk)
Will give you a file-level mirror (not a byte-level mirror but that should be fine) of your files. Just make sure that both of your disks are assigned to the same drive letter (if not, just make it robocopy twice, once to each target drive, and the missing disk will just fail).
Downsides:
Magnetic media will eventually fail over time. In 10 years time, the chances of getting any data off the disk at all would be < 50%. This may be totally acceptable, but for financial data or mission-critical things this may not be.
The disks will fail at a higher rate than your source, mainly because they'll be spending a lot of their life in transit, bumping around in someone's bag and car, being moved all the time. So be prepared to replace them every 2 years or so.
By using the
robocopymethod any other computer that can read an NTFS disk can read your backups
Upsides:
Cheap. Very cheap. No need to buy tapes or tape drives.
By using the
robocopymethod any other computer that can read an NTFS disk can read your backups
I strongly recommend you go with a linux-based disk backup solution with something like rsnapshot. I think that's the only way in your price range to get the kind of storage capacity that you need.I recently set this up at a small business with similar money constraints and it works well. One caveat: you need a linux server, I'm guessing from your description that this is an all-windows setup. Maybe you can convert a windows machine to linux?
You can buy two 1TB drives and USB enclosures for just under $200. For a little more you can get two 2TB drives, which might be a good idea given the amount of data you are talking about. For backups, the performance of the disks over USB is perfectly adequate.
Once you have the two drives in the enclosures, you can configure a linux machine to automount them whenever they are connected, and then rsnapshot makes snapshot backups to the drive. You can configure the snapshots to balance disk usage and number of backups, but since the snapshots are done with hardlinks, only changed files in the snapshots take up more disk space.
A nice feature of the automounter solution is that when the drives aren't in use, they are automatically unmounted. This means you don't have to do much training to get someone in the office to swap the drives - just tell them to check if the light is flashing, and unplug if it isn't.
This setup is very simple and has proven robust in the year it's been running in the small company where I set it up. Someone in that office just swaps the drives once a week and takes the swapped drive home. Having snapshots is a really nice feature because it makes it really easy to recover files in the case of accidental deletions. This tends to come up every few months in my experience. Of course, if you are just backing up very large files snapshots may be a lot of overhead.
rsnapshot also handles backing up other machines, via ssh connections. I don't think it can do much with windows ervers though - the rsnapshot solution is fairly linux-centric. However, the rsnapshot faq does indicate you can back up windows machines using cwRsync.
I would suggest using CrashPlan, Crashplan is file backup, it uses VSS of windows to backup the files. If you backup to their offsite then it costs money (it is reasonable), but if you use it for only onsite then it is free. I suggest having onsite and offsite backup, but if you don't want to spend alot, then you can backup for free to the local extenal hard drive and you can also backup to another external hard drive in another computer.
It also have file version, which means you can restore a specific file that was changed. Restore deleted files. it easy setup. It doesn't backup SQL Server.
You can install Crashplan on all machines and point the backup to the external hard drive on the server. Great software and easy setup.
What's really good about it that it sends you alerts to your email for free, so you can monitor it.