here's what I use (still running 4.5++ in a dos window):
*(backup 081202 reloads and backs up from the server or a standalone to a pen drive) del c:\a\o.r* *(deletes old copy) con o *(my main database name) cls wri 'Please check your entire installation for any other computers that' wri 'might have an obase connection to this one. If any do, please' wri 'have each machine exit obase BEFORE continuing.' t='n' fil t usi 'Proceed with backup now? (y/n): ' if t ne 'y' then wri 'Backup cancelled' red goto clv endi set mes on set err mes on relo c:\a\o disc wri ' ' wri 'Checking optimized database integrity' zip autochk c:\a\o t='n' wri 'If no errors found, insert the USB file transfer device ' yel wri 'if you want to transport the a copy off site (recommended)' yel wri ' ' fil t usi 'Copy the reloaded database now? (y/n): ' if t ne 'y' then wri 'Backup interrupted' red goto clv endi wri 'Copying to this computers backup directory' yel cop c:\a c:\obak wri 'Copying to the file transfer device' yel wri ' ' wri 'Do not unplug the USB device until its activity indicator goes out' RED wri ' ' cop c:\a e: wri 'Copying the reloaded database back to the main server directory' cop c:\a del c:\a cls wri 'Backup complete. You may remove the transfer device now. LABEL CLV pau
so I've reloaded, checked the reloaded copy with autochk, copied it to a local backup directory, back to the main directory, and to the pen drive that I then sling around my neck. so if the worst happens (my house and my office burn down at the same time) I still have a current copy of my database next to my heart. btw I watch the screen during the reload because occasionally you'll see an error there which I always like to investigate
bill
Fogelson, Steve wrote:
Wanted to see if someone had a batch file for their nightly db maintenance they would be willing to share.
Not sure how you run R:Base by itself in a batch file.
Hoping it will include autochk and a check to see if it ran ok. Not sure how to check for autochk success.. Also reload or unload.
Thanks
Steve Fogelson Internet Commerce Solutions
.
