Creating backup database via scripting

Posted by J.H. Roza

Posted on Wed, 09/09/2015 - 10:12 in Administration & User Management

Does anyone knows if it is possible to make a backup of a database via a javascript report and schedule this via Scheduled Reports of a database?

23k

by Runé Becker

Posted on Wed, 09/09/2015 - 12:21

Why would you need a database backup within an ARIS report?

For such maintenance tasks you may rely on ARIS Server Administrator, which can run in both interactive and batch mode.

And even if you haven't installed ARIS Client on the computer where ARIS Design/Connect Server is installed, you still have that tool as batch program (Linux: arisadm.sh) in folder:

<ARIS installation folder>\server\bin\work\work_abs_<sizing>\tools\arisadm\arisadm.bat

Wrapping that batch in another batch to run regularly database backups in combination with Windows Task Scheduler seems to most customers.

Same counts for tenant backups via ARIS Cloud Controller (acc.bat), where not just all databases are saved outside of ARIS, but also all other ARIS content, such as adjusted ARIS method configuration, all reports/macros/templates/queries, users/groups with along with assigned licenses & privileges, uploaded documents in ARIS Document Storage, deployed processes in ARIS Process Governance, comments in Collabarotion etc.)

Cheers

Rune

by J.H. Roza Author

Posted on Wed, 09/09/2015 - 14:18

I'm investigating if it is possible to replace batch backup jobs that run on the server via Scheduled Tasks by a Scheduled report per database. That way I'm more flexible differentiating backup schedules per database.

regards,

Jan

by Asha Chitan

Posted on Thu, 07/11/2019 - 09:07

Hoi Jan,

Asha hier! Niet meer bij SAG maar Rabobank, ik zit met een gelijksoortig vraagstuk. Is het jou nog gelukt om de databases via scripts automatisch te backuppen? grt. Asha

by Christian Barth

Posted on Thu, 09/10/2015 - 18:13

Dear J.H. Roza,

yes, it is possible. We have developed such a report script for exactly the same issue and set it up as scheduled report.

The report script writes the output data into a directory on the server and it is possible to configure some options, like how many backups should be hold available and which databases should be backed up.

In that way it is possible to make changes to the backup process directly via ARIS client without administration rights on server side.

If you are having any more questions, feel free to send me an email to Christian.Barth@aproo.de as I do not check ARIS community frequently.

Kind regards

Christian Barth