Automate Backup of selected Databases

Stephan Schulz on June 27, 2024

Hi all,

hello everyone. i have the question if i can backup selected databases and save them to a local drive using an automatically executed report by a macro. I use Aris Cloud Enterprise SR24. SoftwareAG sent me these files, but I can't really do much with them?

var oAdminComponent = Context.getComponent("ServerAdmin");
var oDB = ArisData.getActiveDatabase();
var bt = oAdminComponent.backupDatabase(oDB);

Context.addOutputFile(oDB.Name(-1)+".adb,bt);

Does anyone happen to have a finished report that I could use as a guide? Or can someone help me to create one?

Thanks in advance

Tags: #arisenterprise

Bookmark

Notify Moderator

Best Reply

Robert Goldenbaum on July 29, 2024 - 15:52

Well, you could write a script that backups specific databases and puts them on a "local" storage and then schedule the script with the script scheduler.

Please note that the "local" storage (e.g. c:\temp) would then be the c-partition ON THE SERVER. So if you do have remote desktop access to the server - fine...

But normally, daily backups of all databases (and as M. Zschuckelt mentioned the systemDB etc) are done by the ARIS Server administration team... if not, well, think about changing your server administation...

BR Robert

or register to reply.

Show in context Notify Moderator

4 Replies

M. Zschuckelt on June 28, 2024 - 17:19

This seems to be the code of a report that does exactly the same that a user with the privilege backup administrator could achieve in the context menu of a database: Backup and download the active database to an adb file.

So I understand you want to save the database regularly to your local drive? A macro is executed only in your client, i. e. only when you are logged in. And I am not sure what your expectation of "automatically" is? Automatically on what event? Consider that a database backup may take multiple minutes, depending on the size of the database.

A common approach for doing regular backups is the backup of the entire tenant. The advantages of a tenant backup are:

It contains also your method and filters
It contains also your document repository, if you keep the documents in ADS
The backups are performed on the server at any time

or register to reply.

Notify Moderator

Stephan Schulz Author on July 1, 2024 - 08:59 as Reply to M. Zschuckelt

By automatic, I mean that they should be executed regularly without having to select anything manually. For example, a backup of the databases is created and stored every week on Friday at 12:00.

or register to reply.

Notify Moderator

M. Zschuckelt on July 5, 2024 - 13:37 as Reply to Stephan Schulz

I see a conflict between your requirements

get a local backup (I assume your local disk)
do it automatically on a regular schedule

When you are not connected to the ARIS Server there is no way the server could send you a backup of the database.

Also consider that a database may not contain everything you need to restore your system in case of a fatality. Only a tenant backup (containing the SYSTEMDB and all other databases) allows you to restore the system state completely on any ARIS system.

Surely there are use-cases, where database backups suit your needs, e. g. you want to have something to resort back to if anyone messes up something. Then a report like the one above could write the database backup as the file output of the report. Schedule the report Friday at noon and you are there. Please consider that file output of reports is written to the server disk or the ADS component. Depending on the size of your database and frequency of the backup that may grow accordingly in space consumption.

or register to reply.

Notify Moderator

Robert Goldenbaum on July 29, 2024 - 15:52

Best reply

Well, you could write a script that backups specific databases and puts them on a "local" storage and then schedule the script with the script scheduler.

Please note that the "local" storage (e.g. c:\temp) would then be the c-partition ON THE SERVER. So if you do have remote desktop access to the server - fine...

BR Robert

or register to reply.

Notify Moderator