|
none of those solutions will work for a db driven application (or any other application which requires files to remain open). only time you can backup is if you take your db offline.
Jim (or anyone else for that matter), invest in 2+ scsi drives and a raid card. if 1 hd goes down, the mirrors will not only keep your data intact they will also keep your site alive.
also the beauty of a hot-swapable application you can remove one of the harddrives pop it into another box (or the same box if you have yours setup for this) backup the data to your preferred medium and boom, a whole disk image backed up not only on multiple hds but also on a media you can take off-site for increased protection.
you can run ide / serial ata / firewire / software [raid] but SCSI [raid] is still the most efficient to date.
with the cost of a 36GB scsi drive hovering around $200 you can't afford not to do it.
did i mention the mirroring is real time 24/7 dont mistake it for a backup, which it is not, but it sure as hell lets you sleep easier at night.
|