Backing up and recovering the relational databases

The recommended method to protect the relational databases is to use the catalog backup and recovery interfaces.

A temporary backup of the NBDB and BMRDB databases can be made for extra protection before database administration activities such moving or reorganizing the database files.

Table: Commands to back up and recover relational databases

Command

Description

nbdb_backup.exe

Use nbdb_backup to make either an online or an offline copy of the NBDB database files and the BMRDB database files in a directory. The transaction log is not truncated by using nbdb_backup. Transaction logs are managed only by using the catalog backup.

Install_path\NetBackup\bin\nbdb_backup.exe [-dbn database_name][-online | -offline] destination_directory

-dbn database_name only backs up the specified database (NBDB or BMRDB).

-offline shuts down the database and access to the database. Connections to the database are refused at this time. The SQL Anywhere service does not shut down.

Note:

Using this command (or the NetBackup Database Administration utility) to back up the NetBackup database can potentially break the consistency between the NetBackup catalog and the database. This loss of consistency can lead to loss of data. Use this command (or the NetBackup Database Administration utility) to back up the NetBackup catalog only as a precautionary measure.

Note:

The transaction logs are not truncated by using nbdb_backup. A catalog backup must be run to truncate the logs.

nbdb_restore.exe

Use nbdb_restore to recover from a database backup that was made using nbdb_backup.

Install_path\NetBackup\bin\nbdb_restore.exe -recover source_directory

Logs are recorded in the \admin directory.

Note:

Using this command (or the NetBackup Database Administration utility) to restore the NetBackup database can potentially break the consistency between the NetBackup catalog and the database. This loss of consistency can lead to loss of data. Use this command (or the NetBackup Database Administration utility) to restore the NetBackup catalog only as a precautionary measure.