Under unix I would recommend to do this by cronjob.
I`ve written a at job under windows to dump the whole database very night.
Filename=date&time.sql
So you can restore the DB by day / time. (don`t forget to backup the storage dir also)
It works fine for me, execpt for few adjustments. So I would like to contatct the author if he is willing to update the script whit this adjustments which I think would be usefull to other users.
--
Nothing is impossible. Not if you can imagine it!