nthurman wrote on Thursday, August 26, 2010:
Michael,
database issues can occur without warning and “always” when you don’t need one. It may be due to a hard disk error, memory error, process failure, or any number of other issues. You may (hopefully) never see this issue again or it may happen in the next 10 minutes. That is why we stress you make regular backups of your system and database. At least daily but more frequently (hourly) is better. Depending on the size of your practice you may want to invest in an external hard drive (or several) to keep regular off-site copies of your system.
I keep hourly dumps of the database, nightly backups of the entire system to a local NAS, and weekly archives to an off-site (encrypted) facility. This may seem extreme but, having worked in this industry for many years, I have first hand experience watching hard drives turn into iron filings.
Look on the wiki if you need examples of backup scripts and feel free to email me if you have questions.