cancel
Showing results for 
Search instead for 
Did you mean: 

MSSQL database "master" is always skipped during online backup

MiloHaze
Level 3
Certified

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

0 REPLIES 0