01-12-2021 11:35 AM
i need to write a script to backup the act database.
need to use the command line.
not using the gui act user interface.
i cannot find any help documents about that.
01-13-2021 01:51 AM
Here is a good resources for command lines from Pat -
The only other way I know of doing this is at SQL level
Details here -
01-13-2021 05:54 AM
actdiag, really not a good program.
that this is the best act can do for command line backups?
when backing up using the act program, a .zip file is created with a unique file name.
when using actdiag, a non-compressed file is created, always with the same file name.
that means now my script will have to compress and rename that backup file.
01-14-2021 03:28 AM
Forgive me for asking but why do you not use the automated backup Scheduler that comes with ACT and then backup the zip file it creates? This is how almost all of my clients backup to internal backup system or to off site disaster recovery.
01-14-2021 06:04 AM
01-14-2021 06:20 AM
If it works with manual backup but not from Scheduler it is often permissions of where you are saving it if not on the local machine. You can change the windows user under Services to a network administrator user that often fixes this. (Ignore this post if it fails on the local drive as well.)
01-14-2021 09:27 AM - edited 01-14-2021 09:30 AM
i am going to use the scheduler and then run a .cmd script task at a set time after that backup would have completed.
i just found out that the .zip file is not password protected and the data is not encrypted.
that the attachments can be viewed by anyone.
really, very shocking.
so what is the point of a password if it does not protect my valuable data.
seem that i will have to zip the zip to get an encrypted zip....
02-16-2021 08:31 PM - edited 02-17-2021 08:20 PM
The following examples show how to run database maintenance tasks from a command line.