Moving NBDB database files after installation

In the case of large databases, consider changing the location of the database files or splitting the database files into multiple directories to improve performance.

Note:

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

Note:

Run a catalog backup to back up NBDB and BMRDB both before and after moving the database files.

To move the NBDB and the BMRDB database files

  1. Perform a catalog backup.

  2. Shut down all NetBackup services by typing the following command:

    Install_path\VERITAS\NetBackup\bin\bpdown

  3. Start the SQL Anywhere service by typing the following command:

    Install_path\VERITAS\NetBackup\bin\bpup -e SQLANYs_VERITAS_NB

  4. Use one of the following methods to move the existing data, index, and transaction log files:

    • Use the NetBackup Database Administration utility.

      See Moving the NetBackup database files.

    • Type the following command:

      Install_path\VERITAS\NetBackup\bin\nbdb_move.exe

      -data data_directory

      -index index_directory -tlog log_directory

      You can run the nbdb_move command at any time because it does not drop the database and recreate it. Thus, all data is preserved.

      If a mirrored transaction log is in use, type the following command:

      Install_path\VERITAS\NetBackup\bin\nbdb_move.exe -data data_directory

      -index index_directory -tlog log_directory

      -mlog log_mirror_directory

  5. Start all services by typing the following command:

    Install_path\VERITAS\NetBackup\bin\bpup

  6. Perform a catalog backup.