The adsbackup utility is a command-line utility that wraps the calls to the backup and restore canned procedures. This utility can easily be added to an operating system scheduler to create scheduled backups.
The adsbackup utility is installed to the same directory as the Advantage Database Server executable. A java utility (adsbackup.jar) is also installed to be used on Novell Netware servers.
Example Usage
For this example, lets assume we are using a Microsoft Windows server, and our data resides in a data dictionary called "motors.add" in the c:datamotors directory. The motors.add dictionary has an ADSSYS user password of "secret".
Before running a test of adsbackup, we will create two new subdirectories called "backup" and "restore" in the c:datamotors directory. We will send our backup image to the "backup" directory, and we will restore into the "restore" directory (as opposed to restoring over the original database, which is possible, but not the safest approach).
Next, we will run the following test command to test our backup:
adsbackup -psecret c:datamotorsmotors.add c:datamotorsbackup
Then, we will add this new command to the Windows Scheduler to backup our database every night:
1.
Open the Control Panel
2.
Open Scheduled Tasks
3.
Click "Add Scheduled Task"
4.
Follow the wizard prompts to add adsbackup.exe as a scheduled task
Each time adsbackup is called, it will create a new backup log table of the form BACKUP_CCYYMMDDHHMMSS, where CCYYMMDDHHMMSS is a timestamp based on the date and time the backup command was started. Command line options exist to alter the location and name of this file if you would like to customize the logging functionality of the utility.
If at some point you need to restore from this backup image, you would execute the following command to restore into the "restore" directory:
adsbackup –r –psecret c:datamotorsbackupmotors.add c:datamotorsrestoremotors.add
Or, you could execute this command to restore over the existing or damaged data (only recommended after making a copy of the data you are about to overwrite):
adsbackup –r –psecret c:datamotorsbackupmotors.add c:datamotorsmotors.add
Note that in both of the commands above, the destination path includes the .add filename. This is different than when performing a backup. While not common, if you want to rename the dictionary file when restoring with this command, you can do so by specifying a different dictionary name in the destination path.
Whenever you set up a new backup, it is a good idea to test a restore operation and run your application against the restored data to verify the backup and restore were successful.
Command Line Usage
To backup a directory of free tables:
adsbackup [options] <src path> <file mask> <dest path>
src path
The path to the free tables you want to back up. This path can be UNC ( myservermysharemydir ) or a drive letter ( c:mydir ) if connecting to a Microsoft Windows server. If using drive letters, keep in mind the drive letter must be recognized by the server machine, any drives mapped on the client executing the backup command are irrelevant. If using a drive letter for the source path, the drive must be a "local" drive; it cannot be a mapped drive. If connecting to a Novel Netware server or a Linux server, UNC paths are recommended.
file mask
A file mask similar to "*.adt" or "*.dbf" which will be used to determine what tables should be included in the backup image.
dest path
Path to place the backup image in. This path can be UNC ( myservermysharemydir ) or a drive letter ( c:mydir ) if connecting to a Microsoft Windows server. If using drive letters, keep in mind the drive letter must be recognized by the server machine, any drives mapped on the client executing the backup command are irrelevant. Unlike the source path, the destination path can use any drive letter, even one that references a mapped drive. If connecting to a Novel Netware server or a Linux server UNC, paths are recommended.
To backup a data dictionary and the associated tables:
adsbackup [options] <src database> <dest path>
src database
The path to the data dictionary you want to back up. This path can be UNC ( myservermysharemydirmydd.add ) or a drive letter ( c:mydirmydd.add ) if connecting to a Microsoft Windows server. If using drive letters, keep in mind the drive letter must be recognized by the server machine, any drives mapped on the client executing the backup command are irrelevant. If using a drive letter for the source path, the drive must be a "local" drive, it cannot be a mapped drive. If connecting to a Novel Netware server or a Linux server UNC, paths are recommended.
dest path
Path to place the backup image in. This path can be UNC ( myservermysharemydir ) or a drive letter ( c:mydir ) if connecting to a Microsoft Windows server. If using drive letters, keep in mind the drive letter must be recognized by the server machine, any drives mapped on the client executing the backup command are irrelevant. Unlike the source path, the destination path can use any drive letter, even one that references a mapped drive. If connecting to a Novel Netware server or a Linux server UNC, paths are recommended.
Java Command Line Usage
The following are a few examples using the java adsbackup utility. The paths will vary depending on your installation.
Note You may need to specify the IP address of the Advantage Database Server if your NetWare server cannot resolve the server name to an IP address. See the -s option above.
To backup a directory of free tables:
java -cp main:adsadsbackup.jar;main:adsadsjdbc.jar AdsBackup servershare *.adt serversharebackup
To restore a directory of free tables:
java -cp main:adsadsbackup.jar;main:adsadsjdbc.jar AdsBackup -r serversharedatabackup *.adt serversharedata
To backup a data dictionary:
java -cp main:adsadsbackup.jar;main:adsadsjdbc.jar AdsBackup -pPassword serversharedatadatadictionary.add serversharedatabackup
To restore a data dictionary:
java -cp main:adsadsbackup.jar;main:adsadsjdbc.jar AdsBackup -r -pPassword serversharedatabackupdatadictionary.add serversharedatadatadictionary.add
Command Line Parameters
The following command line parameters can be passed to the adsbackup utility as options:
-a Prepare a database for a differential backup
This option will create a new backup image and also initialize the source data so it can be used in a subsequent differential backup.
-c[ANSI|OEM] Character type (default ANSI)
This option sets the character type of the SQL statement or connection used by the backup utility. This is the character type used to open each table and transfer its data.
-d Don't overwrite existing backup tables
The default behavior is to overwrite all tables when doing a backup or restore operation. Use this option to cause a warning to be logged instead of overwriting existing tables.
-f Differential backup
This option will perform a differential backup, where only tables and records that have been modified since the last backup will be processed. Only use this option on databases that you have previously called adsbackup on using the –a option to initialize the differential backup.
-h[ON|OFF] Rights checking (default ON)
This options sets the rights checking mode of the SQL statement or connection used by the backup utility. This is the rights checking mode used to open each table and transfer its data.
-i<file1, .. ,filen> Include file list
-e<file1, .. ,filen> Exclusion file list
These options can be used to provide a list of tables to include or 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 Backup metadata only
This option will make a backup or restore only copy of the data dictionary. None of the tables will be copied.
-n<path> Path to store the backup output table
This option can be used to specify the location you would like the backup log table to go to.
-o<filepath> Path and filename to the backup output table
This option cannot only be used to specify a specific path for the backup log, but can also specify a file name.
-p Password(s)
Database password for the ADSSYS user if source path is a database.
List of free table passwords if source path is a directory. 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] Locking mode, proprietary or compatible (default PROP)
This option sets 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.
-r Restore database or free table files
Use this option to perform a restore instead of a backup (which is the default behavior).
-s<server path> Connection path of ADS server to perform backup or restore
In most situations, the adsbackup utility can determine the connection path to use by examining the source path. If you are having connection problems, however, or want to use a specific connection path when performing the backup or restore, you can use this option.
-t<server port> Connection port of Advantage Database Server to perform the backup or restore (default 6262)
This option defines the server port the adsbackup utiltity connects to when using the Advantage JDBC Driver. This option is only valid with the java adsbackup utility.
-u[ADT|CDX|NTX] Table type (default ADT)
This options 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. Note this also determines the table type of the log file produced by the backup or restore procedure.
-v[1-10] Lowest level of error severity to return (default 1)
Use this option to configure adsbackup’s tolerance of warnings or low severity errors.
Adsbackup.exe can be located on underfiles (vpnuserfiles) under the tools folder. |
|
|
|
|
|
| User Opinions |
|
| 0% |
 |
100% |
 |
| 1 total votes. |
|
|
| How would you rate this answer? |
|
|
|
