A command line backup utility for use with Advantage Database Server. The adsbackup utility collects all the required information to perform a backup or restore, and executes the backup or restore on the specified server. This utility is located in <UnwiredPlatform_InstallDir>\Servers\Advantage910\Server.
adsbackup.exe [options] <src path> <file mask> <dest path>
adsbackup.exe [options] <src database> <dest path>
| Option | Description |
|---|---|
| -a | Creates a new backup image and initializes the source data so it can be used in a subsequent differential backup. |
| -c [ANSI|OMI] | Sets the character type of the SQL statement or connection used to open each table and transfer its data. Default: ANSI. |
| -d | Logs a warning before overwriting existing tables. The default behavior is to overwrite all tables when performing a backup or restore operation. |
| -f | Performs a differential backup. Includes only tables and records that have been modified since the last backup. Use this option only on databases on which you have previously called adsbackup -a to initialize the differential backup. |
| -h [ON|OFF] | Sets the rights-checking mode (used to open each table and transfer its data) of the SQL statement or connection used by the backup utility. |
| -i <file1, file2...> | Provides a list of tables to include in the backup or restore command. When using a data dictionary, specify the table name in the dictionary. When using free tables, specify the base table name including the file extension; for example, "table1.adt". |
| -e <file1, file2...> | Provides a list of tables to exclude from the backup or restore command. When using a data dictionary, specify the table name in the dictionary. When using free tables, specify the base table name including the file extension; for example, "table1.adt". |
| -m | Makes a backup or restore copy of only the data dictionary. Therefore, only metadata is backed up. |
| -n <path> | Specifies the location in which to store the backup log table. |
| -o <filepath> | Specifies a file name, along with the file path to the backup log table location. |
| -p | If the source path is a database, indicates the database password for the user. If the source path is a directory, lists the free table passwords. Free table usage can pass a single password for all encrypted tables, or a name=value pair for each table; for example, "password_for_all" or "table1=pass1;table2=pass2". |
| -q [PROP|COMPAT] | Specifies the locking mode of the SQL statement or connection used by the backup utility. This is the locking mode used to open each table and transfer its data; either proprietary (PROP) or compatible (COMPAT). |
| -r | Performs a restore instead of a backup (which is the default behavior). |
| -s <server path> | Specifies the connection path of the ADS server to perform the backup or restore operation. In most situations, adsbackup can determine the connection path to use by examining the source path. Use this option if you are having connection problems or want to use a specific connection path when performing the backup or restore. |
| -t <server port> | Defines the server port adsbackup connects to when using the Advantage JDBC Driver. This option is valid only with the Java adsbackup utility. Default: 6262. |
| -u [ADT|CDX|NTX] | Sets the table type of the SQL statement or connection used by the backup utility. This is the table type used to open each table and transfer its data. This also determines the table type of the log file produced by the backup or restore procedure. |
| -v [1-10] | Configures the lowest level of error severity to return. Default: 1. |
You can use adsbackup in conjunction with the Unwired Server database file recovery tool MORecover. See Sybase Unwired Platform Administration Guide > System Reference > Command Line Utilities > Unwired Server Runtime Utilities > Unwired Server Database File Recovery (MORecover) Utility.
For more information on adsbackup.exe usage and sample use cases, see the Advantage Database Server documentation.