Using dbbackex to perform user-directed operations for SQL Server
dbbackex is a command line interface program you can use to perform backups and restores of SQL Server. To start dbbackex, run the following from a command prompt:
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 NetBackup uses 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.