About the NetBackup relational database (NBDB) installation on Windows

Article:HOWTO68212  |  Created: 2012-02-06  |  Updated: 2013-07-18  |  Article URL http://www.symantec.com/docs/HOWTO68212
Article Type
How To


Environment

Subject


About the NetBackup relational database (NBDB) installation on Windows

The following information can help you to install and operate 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). NBDB contains the NetBackup Authorization database, 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 About the Enterprise Media Manager on Windows.

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

See Moving NBDB database files after installation on Windows.

Note:

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

Note:

On master servers that experience heavy use, the Sybase SQL Anywhere relational database service may require extra space in the directory that contains its temporary files.

This location is indicated by the Sybase SATMP environmental variable. Indicate the temporary directories as follows:

UNIX: /usr/openv/tmp/sqlany

Windows: Use the server's temporary directory as indicated in the registry.

See the Sybase SQL Anywhere documentation for details on setting the variable.

The following procedure is performed automatically during installation in the order presented. You can also use the same procedure to manually install the database independently.

Installing the NetBackup database

  1. 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 NetBackup server.conf file on Windows.

  2. 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 on Windows.

  3. 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

  4. The NetBackup database is created:

    Install_path\VERITAS\NetBackupDB\data\NBDB.db

  5. DBA password is set for the NetBackup database in vxdbms.conf:

    VXDBMS_NB_PASSWORD = encrypted_password

  6. 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 authorization database files for NetBackup Access Control:

      Install_path\VERITAS\NetBackupDB\data\NBAZDB.db

    • The NetBackup transaction log, necessary for recovering the database:

      Install_path\VERITAS\NetBackupDB\data\NBDB.log

    • The bpjobd database file:

      Install_path\VERITAS\NetBackupDB\data\JOBD_DATA.db

  7. 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.)

  8. The following command initializes the EMM data:

    Install_path\VERITAS\Volmgr\bin\tpext.exe

    See About NetBackup master server installed directories and files on Windows

    See About the NetBackup configuration entry on Windows

    See Sybase SQL Anywhere server management on Windows

    See Sybase SQL Anywhere and clustered environments on Windows

    See Post-installation tasks on Windows

    See Unloading the NetBackup database on Windows

    See About catalog backups on Windows

    See Moving the NetBackup database from one host to another on Windows


Legacy ID



v41724862_v71296339


Article URL http://www.symantec.com/docs/HOWTO68212


Terms of use for this information are found in Legal Notices