We do something very similar at our practice, but we backup the database files every half day onto a flash drive using the following text BATCH file I wrote for my staff to use:
@ECHO OFF
CD\PROGRA~1\AMAZIN~1\
ECHO Make sure flash drive is in USB port on front of your computer.
ECHO Back-up process takes approximately 2 minutes to back-up 6 files.
PAUSE
CLS
ECHO Thank you.
ECHO BACKING UP AMAZING CHARTS DATABASE FILES...
ECHO 6 files to copy
ECHO Copying files... Please do NOT remove the flash drive device in drive E
ECHO Please wait
COPY AmazingCharts.mdb F:\BACKUP\
COPY AmazingMeds.mdb F:\BACKUP\
COPY billing.mdb F:\BACKUP\
COPY codes.mdb F:\BACKUP\
COPY import.mdb F:\BACKUP\
COPY schedule.mdb F:\BACKUP\
CLS
ECHO BACKUP COMPLETE
ECHO Thank you for taking the time to back-up Amazing Charts
ECHO It is now safe to remove the flash drive device in drive F
PAUSE
