Terminating database connections
Before you run nbdb_unload, shut down NetBackup to terminate all active connections to the database. Shutting down NetBackup eliminates any possible concurrency problems.
To terminate database connections on Windows
- Shut down all NetBackup services by typing the following command:
install_path\NetBackup\bin\bpdown
- In the Windows Services Manager, restart the service titled NetBackup Relational Database Manager.
- Use one of the following methods to terminate database connections:
Use the NetBackup Database Administration utility.
See Using the NetBackup Database Administration utility on Windows.
Run nbdb_unload and indicate the outputs (database name, table lists, or schema only) and the destination directory.
- Stop the SQL Anywhere service by typing the following command:
install_path\NetBackup\bin\bpdown -e SQLANYs_VERITAS_NB
- Start all NetBackup services by typing the following command:
install_path\NetBackup\bin\bpup
To terminate database connections on UNIX
- Shutdown all NetBackup daemons by typing the following command:
/usr/openv/netbackup/bin/bp.kill_all
- Start the SQL Anywhere daemon by typing the following command:
/usr/openv/netbackup/bin/nbdbms_start_stop start
- Start only the database server by using /usr/openv/netbackup/bin/nbdbms_start_stop start
- Use one of the following methods to terminate database connections:
Use the NetBackup Database Administration utility.
See Using the NetBackup Database Administration utility on UNIX.
Run nbdb_unload and indicate the outputs (database name, table lists, or schema only) and the destination directory.
- Shut down the database server by using /usr/openv/netbackup/bin nbdbms_start_stop stop.
- Stop the SQL Anywhere daemon by typing the following command:
/usr/openv/netbackup/bin/nbdbms_start_stop stop
- Start all NetBackup daemons by typing the following command:
/usr/openv/netbackup/bin/bp.start_all
Veritas does not recommend using reload.sql to make a copy of the relational databases in a production environment. Use the NetBackup Database Administration utility or nbdb_backup to make a physical copy or use nbdb_move to relocate the database files.