Installing the NetBackup relational database (NBDB)

This topic contains the information that describes the proper installation and operation of the Sybase SQL Anywhere relational database management system.

Generally, the implementation of Sybase SQL Anywhere in the NetBackup catalog is transparent. NetBackup installs Sybase SQL Anywhere during the master server installation as a private, non-shared server for the NetBackup database (NBDB). The NetBackup database (NBDB), contains the Enterprise Media Manager (EMM) data as well as other NetBackup data that NetBackup services use.

The same installation of Sybase SQL Anywhere is used for the optionally-licensed product, Bare Metal Restore (BMR) and its associated database (BMRDB). The BMR database is created during the BMR installation process.

By default, the NetBackup relational database (NBDB) is installed on the master server. The master server is also the default location for the Enterprise Media Manager (EMM) server. Since EMM is the primary user of NBDB, the NetBackup database always resides on the same computer as the Enterprise Media Manager.

See Enterprise Media Manager domain requirements.

For performance reasons, the EMM server and the relational database can be moved to another server.

See Moving NBDB database files after installation.

Note:

NetBackup does not support saving the NetBackup relational database (NBDB, including the EMM data) to a remote file system such as NFS or CIFS.

The following procedure is performed automatically during installation in the order presented. The procedure can be performed manually to install the database independently.

NetBackup database installation

As part of the NetBackup master server installation, the SQL Anywhere server is created. The server parameters are set in the server.conf file in the following location:

Install_path\VERITAS\NetBackupDB\conf\server.conf

See About the server.conf file.
The following entry is added to the registry to set the database location:

HKEY_LOCAL_MACHINE\SOFTWARE\VERITAS\NetBackup\CurrentVersion\Config\VXDBMS_NB_DATA

See About the NetBackup configuration entry.
The VxDBMS configuration file for NetBackup is created. This file requires the read and write permissions of a Windows administrator:

Install_path\VERITAS\NetBackupDB\data\vxdbms.conf
The NetBackup database is created:

Install_path\VERITAS\NetBackupDB\data\NBDB.db
DBA password is set for the NetBackup database in vxdbms.conf:

VXDBMS_NB_PASSWORD = encrypted_password
A minimum of four additional database files are created with contiguous space pre-allocated:
- The NetBackup system database file that is mentioned in the following step:
  
  Install_path\VERITAS\NetBackupDB\data\NBDB.db
- The EMM database files:
  
  Install_path\VERITAS\NetBackupDB\data\EMM_DATA.db
  
  Install_path\VERITAS\NetBackupDB\data\EMM_INDEX.db
- The NetBackup transaction log, necessary for recovering the database:
  
  Install_path\VERITAS\NetBackupDB\data\NBDB.log
The SQL Anywhere accounts and schema are created for each of the NetBackup components that make use of the NetBackup database. (For example, EMM_MAIN.)
The following command initializes the EMM data:

Install_path\VERITAS\Volmgr\bin\tpext.exe