Unloading the NetBackup database
Use the NetBackup Database Administration utility or the nbdb_unload command line utility to dump the entire NetBackup or Bare Metal Restore databases. These utilities can also be used to dump individual tables (one .dat file is created for each table), or schema. Use either method to create a copy of the SQL Anywhere database that may be requested in some customer support situations.
There should be no active connections to the database when nbdb_unload is run.
When either method is used, a reload.sql script is generated. The script contains all the code that is required to recreate the database. Veritas Technical Support uses this script and the associated files to assist in support cases.
On Windows:
install_path\NetBackup\bin\nbdb_unload.exe [-dbn database_name] [-t table_list] [-s] destination_directory
On UNIX:
/usr/openv/db/bin/nbdb_unload [-dbn database_name] [-t table_list] [-s] destination_directory
In the script where:
-dbn database_name
database_name is NBDB (default) or BMRDB.
-t table_list
Must list the owner of the table, then the table name. For EMM, the account EMM_MAIN owns all tables.
nbdb_unload -t EMM_MAIN.EMM_Device, EMM_MAIN.EMM_Density
-s
No data is dumped, only schema.
destination_directory
Specify the location where the dump is created.