MSSQL database "master" is always skipped during online backup
Hello,
During a full Database on line backup, all databases but "master" complete successfully.
The final status of the job is "1" with only "master" database skipped.
Same thing happens with the second template and final status is "2".
Also, there are no other backups running for that client server when the failures occur.
According to the database admin, the master database is in simple recovery mode.
Any ideas what may cause such behavior?
In the logs I've found only this error message:
--------------------------------------------
8/9/2011 7:57:41 AM - Info dbclient(pid=2312) ERR - Error <master> is involved in another operation.
8/9/2011 7:57:42 AM - Info dbclient(pid=2312) INF - OPERATION #1 of batch C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_t.bch FAILED with STATUS 3 (0 is normal). Elapsed time = 10(0) seconds.
8/9/2011 7:57:44 AM - Info dbclient(pid=2312) INF - Results of executing <C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_t.bch>:
8/9/2011 7:57:44 AM - Info dbclient(pid=2312) <0> operations succeeded. <1> operations failed.
8/9/2011 7:57:44 AM - Info dbclient(pid=2312) INF - The following object(s) were not backed up successfully.
8/9/2011 7:57:45 AM - Info dbclient(pid=2312) INF - master
8/9/2011 7:57:47 AM - Error bpbrm(pid=25565) from client apslcis013b: ERR - command failed: none of the requested files were backed up (2)
-----------------------------------------
Netbackup master server is 7.1 on HP-UX platform.
Client server OS is Win 2003 standard SP2
Client server SQL is MS SQL Enterprise 8.00.2055 (SP4)
Client server Netbackup client is 7.1
Templates used for backup:
On line Database backup:
BATCHSIZE 16
OPERATION BACKUP
DATABASE $ALL
SQLHOST "SQLSERVER"
NBSERVER "NBMASTER"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
ENDOPER TRUE
Only master Database backup:
OPERATION BACKUP
DATABASE "master"
SQLHOST "SQLSERVER"
NBSERVER "NBMASTER"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
ENDOPER TRUE
