At 07:41 AM 1/17/2008, Chuck Conrad wrote:
We have a client which is run a server on a 24 hour basis but our
program only accesses the server during the daytime hours. Is there
any way to have the system automatically reload the database and
then backup to a backup directory? I would like the backup to begin
at 1 am.
Chuck,
There are at least three practical approaches to achieve your goal.
01. Create a command file with "UNLOAD ALL" routine, test everything
accordingly, and then simply run that tested routine as Scheduled
Task.
02. If the R:BASE application is also running 24 hours a day, look
into integrating a built-in backup routine using the "Form Timer"
property/feature of R:BASE 7.5 and higher for Windows.
A sample routine "Backup Entire Database" is also included with
Running R:BASE Your Way! (Part 14).
Added techniques of Database Backup and uploading to a remote FTP
site (using R:FTPClient or R:SFTPClient) is also included on the
RBG76/RBG8 2007 Super Advanced Training CD.
03. Create an R:BASE Robot to do this all for you.
Emmitt Dove can shed more light on this cool and robust technique
used in a complex multi-location corporate environment.
Very Best R:egards,
Razzak.
