About the Backup and Restore Database menu options
The Backup and Restore Database menu options let you back up the relational database to the specified directory. You can restore from a previously created backup.
It is recommended to create a backup copy of the database files in the following situations:
Before you move the database.
Before you rebuild the database.
Before you add data space.
Before you add index space.
Before you modify the transaction logging mode from FULL to PARTIAL.
Before you truncate the transaction log.
Note:
Using the NetBackup Database Administration utility to back up and 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 the tool to back up and restore the NetBackup database only as a precautionary measure.
The Backup and Restore Database menu contains the following options.
Table: Backup and Restore Database menu options
Option | Description |
|---|---|
Online Backup | This option lets you make a copy of the database files while the database is active. Other NetBackup activity is not suspended during this time. |
Restore Backup | This option lets you restore from a copy of the database files previously made with either options 1 or 2. The currently running database files are overwritten, and the database is shut down and restarted after the restore is completed. |
Change Directory | This option lets you change the directory location for the files that backup options (1) or (2) create. This directory is the source of the files for the restore option (3). |
More Information