Commands for backing up and recovering the relational databases on Windows

Article:HOWTO34680  |  Created: 2010-10-29  |  Updated: 2011-03-11  |  Article URL http://www.symantec.com/docs/HOWTO34680
Article Type
How To


Environment

Subject


Commands for backing up and recovering the relational databases on Windows

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 used 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.

See About the Enterprise Media Manager (EMM) database on Windows

See Configuring a catalog backup manually on Windows

See Strategies that ensure successful NetBackup catalog backups on Windows


Legacy ID



v41725618_v46435090


Article URL http://www.symantec.com/docs/HOWTO34680


Terms of use for this information are found in Legal Notices