PE

Hi, is there a way to automate a DB backup in ARIS, e.g. by using a report? Is that possible? If yes, could you provide the code please. If no, any other option except backing up the whole ARIS environment?

by Alexander Cherednichenko
Badge for 'Answermachine' achievement
Posted on Fri, 06/14/2024 - 16:19

If you use Enterprise - there is one story, you need to create on the server .bat file with backup commands.

For Advanced we used macroses, e.g. when you log in DB it asks you to create a backup. 

So for what version do you need?

1
by Peter Eichhorn Author
Posted on Mon, 06/17/2024 - 15:18

Hi Alexander,

I am wondering why you can trigger a backup with a macro but not with a report. One is initiated by an action, and the other with a schedule. What is the difference?

However, I like the idea of having a .bat file on the server. Can you please provide me with the code, so that I can create a (weekly) backup of an ARIS DB?

0
by Alexander Cherednichenko
Badge for 'Answermachine' achievement
Posted on Mon, 06/17/2024 - 17:00

Hi, here we are:

@echo off
setlocal enabledelayedexpansion

REM Set the backup directory
set BACKUP_DIR=C:\aris_backup

REM Create a folder with the current date and version
for /f "delims=" %%a in ('wmic OS Get localdatetime ^| find "."') do set datetime=%%a
set CURRENT_DATE=!datetime:~0,4!-!datetime:~4,2!-!datetime:~6,2!
set CURRENT_TIME=!datetime:~8,2!!datetime:~10,2!!datetime:~12,2!
set VERSION=!CURRENT_TIME: =0!
set BACKUP_FOLDER=%BACKUP_DIR%\%CURRENT_DATE%_%VERSION%
mkdir "!BACKUP_FOLDER!"

arisadm10 -s localhost:81 -t default -u system YOUR_PASSWORD reorg all
arisadm10 -s localhost:81 -t default -u system YOUR_PASSWORD backup all "!BACKUP_FOLDER!"
1
by Alexander Cherednichenko
Badge for 'Answermachine' achievement
Posted on Mon, 06/17/2024 - 17:05

This code creates the folder with date and time in the directory 'C:\aris_backup', then it backups all DBs on the server, but instead of the command 'backup all' you can specify the name of the DB you need. 

Then you need to set up window scheduler with this .bat file. Sometimes it is necessary to convert .bat to .exe, depends on your security policies

1
by Peter Eichhorn Author
Posted on Tue, 06/18/2024 - 10:38

That's awesome. I will test it... Cheers mate ;-)

1
by Peter Eichhorn Author
Posted on Tue, 07/09/2024 - 12:13

It finally works... thanks a lot for your advice. It helped a lot...

1

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock