Using the Command Line Interface › Miscellaneous Utility Commands › DumpDB Utility

DumpDB Utility

The DumpDB utility is used to import and export session passwords to and from the Arcserve Backup database. The DumpDB utility dumps only session passwords, it will not export other information about a session. You should run the DumpDB utility on a regular basis so that you can import the session password information back into the database.

Important! If you execute this utility after a database has been purged or pruned, session passwords will not be exported. Therefore, it is important that this utility is run prior to purging or pruning a database.

Syntax

DumpDB.exe -ExportTo <filename> [-from startTime] [-to endTime] [-password <password>]

DumpDB.exe -ImportFrom <filename> [-password <password>]

DumpDB.exe -as [[-domain\]primary -exportTo [filename] [-from startTime] [-to endTime] [-password <password>]]

DumpDB.exe -as [[-domain\]primary -importFrom [filename] [-password <password>]] 

-as

Lists all of the domains in the Arcserve Backup database that are used by the local Arcserve Backup server, and then closes.

Important! The DumpDB -as argument lets you analyze only the Arcserve Backup database associated with the Arcserve Backup server where you execute the utility. The utility not analyze data in any other Arcserve Backup database.

-as primary

If you specify a primary server name, DumpDB searches the Arcserve Backup database and responds as follows:

• If DumpDB does not detect the server name in the Arcserve Backup database, DumpDB closes.
• If DumpDB detects one record of the server name in the Arcserve Backup database, DumpDB completes the execution.
• If DumpDB detects more than one record of the server name in the Arcserve Backup database, DumpDB warns you and then closes.

Note: This argument must be used with -exportTo and -importFrom.

-as domain\primary

If you specify a primary server name and a domain name, DumpDB searches the Arcserve Backup database and responds as follows:

• If DumpDB does not detect the server name and domain name in the Arcserve Backup database, DumpDB closes.
• If DumpDB detects one record of the server name and domain name in the Arcserve Backup database, DumpDB completes the execution.
• If DumpDB detects more than one record of the server name and domain name in the Arcserve Backup database, DumpDB warns you and then closes.

Note: This argument must be used with -exportTo and -importFrom.

-ExportTo

Exports session passwords stored in a database to specified target file.

-password

If include this switch and specify a password during exporting, the output file will be encrypted by this password.

-ImportFrom

Imports session passwords stored in a specified file to a database.

-password

If you included a password during exporting, you will need to input the correct password during importing, otherwise the import operation will fail.

Time format:

The time format for scheduling when to run the DumpDB utility can be specified as a calendar time period or a number of days ago time period.

• To specify calendar date, use the following format:

  YYYYMMDD[hh[mm[ss]]]
  

  Note: The year, month, and day are required. The hours, minutes, and seconds are optional.

• To specify a number of days ago, use the following format:

  nnnn (0 <= nnnn <= 9999)
  

  Note: The parameter range for number of days ago is 0-9999.

Examples: Syntax

The following are examples of syntax for the DumpDB utility:

• The example that follows exports session passwords for the previous 100 days:

  DumpDB.exe -exportto "c:\sesspwd.dump.out" -from 100
  

• The example that follows exports session passwords for all days since January 1, 2008:

  DumpDB.exe -exportto "c:\sesspwd.dump.out" -from 20080101
  

• The example that follows imports session passwords to the database:

  DumpDB.exe -importfrom "c:\sesspwd.dump.out"
  

  Note: The imported session passwords can only be accessed by current Arcserve Domain

• The example that follows lists all of the domains in the Arcserve Backup database that are used by the local Arcserve Backup server.

  DumpDB.exe -as
  

• The example that follows exports session passwords for specified primary:

  DumpDB.exe -as primaryname -exportto "c:\sesspwd.dump.out"
  

• The example that follows imports session passwords to the database for specified primary:

  DumpDB.exe -as primaryname -importfrom "c:\sesspwd.dump.out"
  

  Note: The imported session passwords can only be accessed by the Arcserve Backup domain that relates to the specified primary server.

• The example that follows exports session passwords from domain "GREEN" with primary server "APPLE" and imports them into domain "PURPLE" with primary server "GRAPE:"

  DumpDB.exe -as green\apple -exportto "c:\sesspwd.green.out"
  

  DumpDB.exe -as purple\grape -importfrom "c:\sesspwd.green.out"
  

• The example that follows exports session passwords from domains “GREEN” with primary server “APPLE” and “RED” with primary server “GRAPE”, and imports them into domains “PURPLE” with primary server “PLUM” and “ORANGE” with primary server “MANGO," when domains “GREEN” and “RED” are from of an Arcserve Database that was restored over the Arcserve Database used by domains “PURPLE” and “ORANGE” using the “Preserve Arcserve Domain Memberships” option:

  DumpDB.exe -as green$\apple$ -exportto "c:\sesspwd.green.out"
  

  DumpDB.exe -as red$\grape$ -exportto "c:\sesspwd2.red.out"
  

  DumpDB.exe -as purple\plum -importfrom "c:\sesspwd.green.out"
  

  DumpDB.exe -as orange\mango -importfrom "c:\sesspwd2.red.out"