What your asking for is a constant backup which I've never heard of a Joomla component doing such a thing. I suppose an ideal solution would be for a way to duplicate the data upon submission. One being stored in the usual tables, and the other going into backup table(s). How to accomplish this is beyond me.

Hi there,

here's my current setup (on other website)
1. In my hosting, I automatically backup database every 15 minutes uninterrupted (evault)
2. All my images are stored in amazon s3

Anytime the site goes berserk, I can easily restore the database for the last 15 minutes, no need for images since it's stored in other server and so are the static ones. Of course that's not cheap, but it's the safest way to go for me. Or you can get akeeba pro and set it up for a cron job every hour or so (uses lots of resources by the way including disk space).

If you are running a mission critical site, and have lots of money to spend on, go with a raid-0 backup. However, this will only solve your problems if you have a disk failure. Other than that, if your site is messed up, you'll still have issues as well. Like Ken mentioned, perform a backup at a shorter interval so that you get the latest data