My other admin has it all figured out. He has a timed script on the server that copies the entire database every 24 hours and another script on his computer that automatically does the backup from the copy a few minutes later. He keeps backups for only so long before automatically deleting them so his computer doesn't get overloaded.
We've never lost anything but if we did it couldn't be more than 24 hours worth.
|