Running ACTDIAG commands from a batch file
Starting with version 14 of the Sage ACT diagnostics tool, ACTDIAG, you can now run some ACTDIAG commands via a command line interface. Using the server NT scheduler you can then have them set to run on a periodic basis.
First off, here’s a list of what you can run via command line. Note, you need to run these on the server hosting the database in question. This data is also on the help file for ACTDIAG, something I don’t thank a lot of people actually look at and should. You can see this same list by typing actdiag /? at a command line in the act for windows program directory.
- A command can be entered with or without preceding / or -. Attach, /Attach, -Attach are acceptable.
- The command line is not case-sensitive. Attach, ATTACH, or attach are acceptable.
The following examples show how to run database maintenance tasks from a command line.
- Attach <database name> <complete adf file path> [optional-<complete alf file path>]-attaches database with or without log file.
- Example: Attach ActDemo c:\databases\ActDemo.adf
- Backup – backs up the database.
- Example: Backup ActDemo c:\Temp\Mybackups
- Check – checks database for errors.
- Delete – deletes database.
- Example: Delete ActDemo CAUTION: This is NOT recoverable.
- Detach – detaches database.
- Downgrade – downgrades a Premium database to a non-premium tier.
- Example: Downgrade ActDemo
- Flush – flushes the procedural cache to release memory.
- License – purges the licenses from the selected database.
- Reindex – reindexes database.
- Repair – repairs database errors. Example: Repair ActDemo
- Restore , – restores database placing files in specified directory folder.
- Example: Restore c:\temp\MyBackups\ActDemo.bak c:\Active_databases
- RestoreAs , , – restores database with new name and places the files in specified directory folder.
- Example: RestoreAs MyDemo c:\temp\MyBackups\ActDemo.bak c:\Active_databases
- ? – displays usage information.
« Kicking up Business Intelligence Data in ACT! | Home | Adding a Custom Template to the Sage ACT Menu bar »