Using dbbackex

Execute dbbackex from a Windows MS-DOS with the following command:

install_path\NetBackup\bin\dbbackex -f file [-p policy][-u userid][-pw password] 
[-s server][-np]

Refer to the description of the following parameters.

file

The name of the batch file, which describes the operations you want to start.

policy

The MS-SQL-Server policy type that is used by NetBackup for the operations that are specified in the batch file.

This parameter is ignored for restore operations. The NetBackup server can retrieve the dump file based entirely on the image names that are specified in the batch file for each restore. The policy name is used for databases backups. If it is omitted, then the NetBackup server uses the first active SQL Server policy that it finds in its policy list. This policy name is used for all of the backup operations that are specified in the batch file.

userid

is the SQL Server user ID for logging into the database management system.

password

is the SQL Server password for logging into the database management system.

server

is the name of the host for the NetBackup master server that you want to back up to or restore from.

If this parameter is omitted, then the client uses the default server according to the Windows NetBackup client configuration. See the NetBackup Backup, Archive, and Restore Getting Started Guide for more information.

-np

tells dbbackex not to create a message box to indicate the operation status when it has completed.

Otherwise, a message appears when dbbackex completes. That message tells you how many operations in the batch file were successful and how many failed.

Note:

Any of the options can be delimited with double quotation marks. For example, use delimiters if the file name contains spaces.

Note:

To protect logon passwords for SQL Server, do not use the -u or -pw parameters. By omitting these parameters, you can force NetBackup for SQL Server to read the default SQL Server logon data from an encrypted file.

More Information

Running batch files

Starting the NetBackup SQL Client for the first time

Using client-based schedulers with dbbackex