About monitoring NetBackup for SQL Server operations
Use the Activity Monitor in the NetBackup Administration Console to monitor NetBackup for SQL Server operations.
The agent also creates its own progress reports that you can view in the NetBackup MS SQL Client interface. Select to view the reports. The reports are saved in install_path\NetBackup\logs\user_ops\MsSql\logs.
Job details and progress reports include the following types of information:
Summary information about the operation
Information about the operation as it progresses
Any error conditions or warnings that cause the operation to fail
The final outcome of the operation, whether it succeeded or failed, and how long it took
The progress reports also provide additional details for operations, including the following:
The SQL Server commands that NetBackup included in the batch file for operation.
OPERATION BACKUP DATABASE "TestDB1" OBJECTTYPE DATABASE COPYONLY FALSE BLOCKSIZE 7 MAXTRANSFERSIZE 6 NUMBUFS 2 STRIPES 1 SQLCOMPRESSION FALSE VERIFYOPTION NONE
The NetBackup server that performed the backup, the SQL Server instance and host you selected for the backup, and other policy information.
NBSERVER "servera" SQLINSTANCE "SQL2K14" SQLHOST "SERVERA" POLICY "sql-server" NBSCHED "full" INF - Setting backup catalog name to: servera
Progress of the backup or restore operation and any errors or failures that SQL Server encountered.
USER - Operation inhibited by NetBackup for Microsoft SQL Server: Only a full or incremental database backup can be performed on database <Archive> because it uses the simple recovery model or has 'truncate log on checkpoint' set. INF - OPERATION #1 of batch C:\NBU\Veritas\NetBackup\dbext\mssql\temp\__01_35_42_508_00.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 6(6) seconds. INF - Results of executing <C:\NBU\Veritas\NetBackup\dbext\mssql\temp\__01_35_42_508_00.bch>: <0> operations succeeded. <1> operations failed. INF - The following object(s) were not backed up successfully. INF - Archive