Friday, July 31, 2009

Tip #60 – AdsBackup Utility Options

The AdsBackup utility is a command line tool that ships with the Advantage Sever and is located in the server directory, C:\Program Files\Advantage 9.10\Server by default. This utility has several options which can be specified to customize how your backup or restore is performed. The basic command line is below.

adsbackup [options] password> <source> [file mask] <destination>

Below is a list of the most commonly used options.

  • -a  Prepare data for a differential backup
  • -d  Don't overwrite existing tables
  • -f  Perform a differential backup
  • -i  Include file list
  • -e  Exclude file list
  • -m  Backup metadata only
  • -p  Password
  • -r  Restore the data
  • -w  Table type map
  • -y  Username for dictionary connection (adssys if not specified)

All of the details about the adsbackup command line tool, along with information about a java version, is available in the help file.


Anonymous said...

Wondering whether this utility may be used to perform an online backup?

Chris Franz said...

Yes, this utility can be used to perform an online backup of both dictionary bound tables and free tables. You can get all the details about using the utility in the help file.