Hello everyone.
I’m looking for some advice on the best way to automate a database to do two things.
1. A very quick repair, just to make sure everything is in line.
2. An automatic Compact and Repair.
3. Make backups within a created folder “example (My Documents)
Ultimately I would like it if I was able to find some code that would automatically find the database within list of databases, back it up in a folder I have assigned for it to be backed up in, Compacted and Repaired then the new Compacted, repaired and tweaked database would go back to the starting location.
If anyone has any advice or experience with this, I would be great full to hear from you
Thanks for your help
Corey
I’m looking for some advice on the best way to automate a database to do two things.
1. A very quick repair, just to make sure everything is in line.
2. An automatic Compact and Repair.
3. Make backups within a created folder “example (My Documents)
Ultimately I would like it if I was able to find some code that would automatically find the database within list of databases, back it up in a folder I have assigned for it to be backed up in, Compacted and Repaired then the new Compacted, repaired and tweaked database would go back to the starting location.
If anyone has any advice or experience with this, I would be great full to hear from you
Thanks for your help
Corey
