Running ACTDIAG commands from a batch file

By Patricia Egen • December 10th, 2012

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.

General Guidelines.

  • 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.
    • Example: Check ActDemo
  • Delete – deletes database.
    • Example: Delete ActDemo CAUTION: This is NOT recoverable.
  • Detach – detaches database.
    • Example: Detach ActDemo
  • Downgrade – downgrades a Premium database to a non-premium tier.
    • Example: Downgrade ActDemo
  • Flush – flushes the procedural cache to release memory.
    • Example: Flush ActDemo
  • License – purges the licenses from the selected database.
    • Example: License ActDemo
  • Reindex – reindexes database.
    • Example: Reindex ActDemo
  • 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.

Leave a Comment

« | Home | »

  • Been sent a support request?

    Click here to enter your ticket number: Ticket

  • Our Business

    Our Mission
    Bridging the gap between technology and business processes. Provide quality business consulting, with an emphasis on technology, maintain superior client relationships and enjoy the trust and respect of our clients

  • Us in a nutshell

    CRM applications
    Data Conversion
    Custom Programming
    SQL Experts
    Lotus Notes
    Stonefield Query
    MS Office Programming
    Business analysis
    Process Workflow
    Social Media and SEO
    Linux, Mainframe
    Been there, done that

  • Facebook Like Us!