Back up options

   Heres my problem which Im sure someone has experience of. I have a database that quite simply because of the importance of the data needs to be backed up after every transaction, how do I achieve this.

options:

1. maybe a little crude, I could email the records to an account after after every transaction using a simple script
2. have two concurrent databases running in two separate machines writing to both rolling back on connection problems.
3. Mirror the database, whats mirroring, I'm using Mysql, not microsoft SQl server but can make the leap to the darkside if deemed necessary.

Thanks

CP Received on Fri Apr 11 2003 - 12:58:23 CEST