Move Database

Click the Move button to change the location of the database files or split the database files into multiple directories.

Changing the location of the database files can improve performance when the database is very large.

Note: Due to performance issues, NetBackup supports database files only on locally attached drives.

The database files are moved for both NBDB and BMRDB, if present.

Enable an option(s) to perform one or more of the following actions:

Move data to
Enabling this option lets the administrator change the location of the data dbspaces. Browse to the new location.
Move index to
Enabling this option lets the administrator change the location of the index dbspaces. Browse to the new location.
Move transaction log to
Enabling this option lets the administrator change the location of the transaction log. The transaction logs, NBDB.log and BMRDB.log, are critical files that are used to recover the relational databases. Browse to the new location.
Create mirrored transaction log at
A mirrored transaction log offers extra protection.
Enabling this option lets the administrator create a mirrored transaction log. Create the mirrored log in a different directory from the original log.
Move mirrored transaction log to
This option is displayed if a mirrored transaction log exists.
Enabling this option lets the administrator change the location of the mirrored transaction log. Browse to the new location. Create the mirrored log in a different directory from the original log.
Stop mirroring
This option is displayed if mirroring is being used.
Enabling this option stops mirroring of the transaction log from occuring. It also removes any existing mirrored transaction log from the directory.


More Information