Hi
this one is a puzzle
I need to come up with a good backup scheme for the database that will make sure that they can restore it if needed and not lose any of their work
I have tried many different solutions, and they've always managed to break it in a new, more sophisticated way
Right now I have a Windows 2000 Backup running every night automatically, but the last issue was that somehow the database got deleted and it obviously didn't get backed up for 2 days before they called me
when I looked, they were using some db14.mdb that was in the same folder with 13 other mdb's with likely names
How that happened - I don't know, but probably they got a box saying that the database is corrupted, and they chose db14 from the list of database, thus wiping out the real database
In any case, I couldn't use it to export tables into the real database, because one user was using db14, and the other db13 and so on
so I just restored last known good database from my backups, but that meant losing 2 days worth of work
Does anyone have a good solution for backing up and restoring database, where I can backup tables every half an hour and keep a backup of a week's work?
Or maybe a different solution?
this one is a puzzle
I need to come up with a good backup scheme for the database that will make sure that they can restore it if needed and not lose any of their work
I have tried many different solutions, and they've always managed to break it in a new, more sophisticated way
Right now I have a Windows 2000 Backup running every night automatically, but the last issue was that somehow the database got deleted and it obviously didn't get backed up for 2 days before they called me
when I looked, they were using some db14.mdb that was in the same folder with 13 other mdb's with likely names
How that happened - I don't know, but probably they got a box saying that the database is corrupted, and they chose db14 from the list of database, thus wiping out the real database
In any case, I couldn't use it to export tables into the real database, because one user was using db14, and the other db13 and so on
so I just restored last known good database from my backups, but that meant losing 2 days worth of work
Does anyone have a good solution for backing up and restoring database, where I can backup tables every half an hour and keep a backup of a week's work?
Or maybe a different solution?