Backing up a multi-user system automatically

[ConvertFromOldNGs]

by Leigh Roberts >> Mon, 30 Nov 1998 4:25:07 GMT

We have a requirement to automatically backup a Jade database at sometime when no humans are using the system. Normally the system operates unattended at remote sites with no intervention. There is a mirrored server used in case of hardware problems. However there is a need to backup the system directory regularly (preferably nightly).

The clients and server run under NT so setting up services to shutdown and start services is straightforward. However it is a little messy because the server may be processing some batch jobs.

Has anyone done this outside Jos and Karma?

What would a good approach be?

Any suggestions welcome.

Leigh

[ConvertFromOldNGs]

by Skull >> Tue, 1 Dec 1998 2:10:28 GMT

The clients and server run under NT so setting up services to shutdown and start services is straightforward. However it is a little messy because the server may be processing some batch jobs.

Do the batch jobs update the database? If they do, then this is indeed messy to do in JADE 4.x. However, if the overnight jobs don't update the database you may want to consider a 'read-only' mode backup.
In JADE 4.x there is a form of database backup, which can be performed by placing the database in archive (or read-only mode). When in archive mode, any updating transactions are rejected with an exception that applications should be prepared to handle. Some JADE users are currently using this facility and schedule backups to take place automatically outside of normal online processing hours. The scheduling is straightforward using timers in a server app.

There are much better solutions to database backup in the pipeline.

[ConvertFromOldNGs]

by Craig Shearer >> Wed, 2 Dec 1998 19:05:31 GMT

This sounds like a good idea Leigh. You should be able to nominate a time during the night that the backup could take place, or alternatively, the actual application could trigger the backup to occur once all the batch processing has terminated.

Craig.

[ConvertFromOldNGs]

by Leigh Roberts >> Tue, 8 Dec 1998 4:59:34 GMT

This sounds almost useable. But I can only see where it is driven by a human administrator. Is this also available to run from a Jade method inside an application?

Who are these Jade users mentioned above?

Leigh

[ConvertFromOldNGs]

by Krull McSkull >> Tue, 8 Dec 1998 5:31:55 GMT

This sounds almost useable.

It is almost usable.

Is this also available to run from a Jade method inside an application? Who are these Jade users mentioned above?

Please contact the JAC or Jade Support group for answers to the above questions.

[ConvertFromOldNGs]

by Leigh Roberts >> Thu, 10 Dec 1998 0:32:09 GMT

Graeme Weeds at JAC has a simple to use set of classes in a schema. Contact him.

Leigh