I have Netbackup setup to backup a few file servers and a MS SQL 2008 DB server. It has been working fine for a long time, and suddenly it failed with status (2) since 2 days back. I've exhausted this forum and found a lot of similar error, but none of the solution works for my case. Another missing clue is that I can't find <install_path>\NetBackup\logs \dbclient\<date>.LOG , other logs is available, such as user_ops\mssql ... etc.

SQL Server: stars01prddb04 (it's a cluster consisting of db01 and db02)

Master/Media Server: stars01prdbk01

So I decided to throw my unique problem here and see if there's anyone with a solution

Followings is the job status from Activity Monitor (Transaction Log backup also display similar error)

 

9/4/2012 12:12:14 AM - Info nbjm(pid=3152) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=93065, request id:{1BDD5A7A-58DF-4DC4-B37D-2DDE9B7EFDAC})  

9/4/2012 12:12:14 AM - requesting resource Backup_SAN_F_Drive

9/4/2012 12:12:14 AM - requesting resource stars01prdbk01.NBU_CLIENT.MAXJOBS.stars01prddb04

9/4/2012 12:12:14 AM - requesting resource stars01prdbk01.NBU_POLICY.MAXJOBS.Daily_SQL_DB_FULL_0030_0130

9/4/2012 12:12:14 AM - granted resource stars01prdbk01.NBU_CLIENT.MAXJOBS.stars01prddb04

9/4/2012 12:12:14 AM - granted resource stars01prdbk01.NBU_POLICY.MAXJOBS.Daily_SQL_DB_FULL_0030_0130

9/4/2012 12:12:14 AM - granted resource Backup_SAN_F_Drive

9/4/2012 12:12:14 AM - estimated 0 Kbytes needed

9/4/2012 12:12:14 AM - Info nbjm(pid=3152) started backup job for client stars01prddb04, policy Daily_SQL_DB_FULL_0030_0130, schedule Full on storage unit Backup_SAN_F_Drive

9/4/2012 12:12:15 AM - started process bpbrm (8016)

9/4/2012 12:12:16 AM - connecting

9/4/2012 12:12:18 AM - connected; connect time: 00:00:02

9/4/2012 12:14:23 AM - Error bpbrm(pid=8016) from client stars01prddb04: ERR - command failed: none of the requested files were backed up (2)

9/4/2012 12:14:23 AM - Error bpbrm(pid=8016) from client stars01prddb04: ERR - bphdb exit status = 2: none of the requested files were backed up

9/4/2012 12:14:28 AM - end writing

none of the requested files were backed up(2)

9/4/2012 12:14:33 AM - Info bphdb(pid=992) done. status: 2: none of the requested files were backed up  

9/4/2012 8:17:24 PM - Info nbjm(pid=6608) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=93083, request id:{6F30C605-D4E1-4153-BEE0-10C9E6F91E7E})  

9/4/2012 8:17:24 PM - requesting resource Backup_SAN_F_Drive

9/4/2012 8:17:24 PM - requesting resource stars01prdbk01.NBU_CLIENT.MAXJOBS.stars01prddb04

9/4/2012 8:17:24 PM - requesting resource stars01prdbk01.NBU_POLICY.MAXJOBS.Daily_SQL_DB_FULL_0030_0130

9/4/2012 8:17:25 PM - granted resource stars01prdbk01.NBU_CLIENT.MAXJOBS.stars01prddb04

9/4/2012 8:17:25 PM - granted resource stars01prdbk01.NBU_POLICY.MAXJOBS.Daily_SQL_DB_FULL_0030_0130

9/4/2012 8:17:25 PM - granted resource Backup_SAN_F_Drive

9/4/2012 8:17:25 PM - estimated 0 Kbytes needed

9/4/2012 8:17:25 PM - Info nbjm(pid=6608) started backup job for client stars01prddb04, policy Daily_SQL_DB_FULL_0030_0130, schedule Full on storage unit Backup_SAN_F_Drive

9/4/2012 8:17:25 PM - started process bpbrm (10004)

9/4/2012 8:17:26 PM - connecting

9/4/2012 8:17:29 PM - Info bpbrm(pid=10004) starting bphdb on client         

9/4/2012 8:17:29 PM - Info bphdb(pid=9492) Backup started           

9/4/2012 8:17:29 PM - connected; connect time: 00:00:03

9/4/2012 8:17:30 PM - Error bpbrm(pid=10004) from client stars01prddb04: ERR - failed executing command <"I:\STARS01PRDDB04_FULL_Backup.bch">    

9/4/2012 8:17:30 PM - Error bpbrm(pid=10004) from client stars01prddb04: ERR - exit status: <-1>     

9/4/2012 8:17:30 PM - Error bpbrm(pid=10004) from client stars01prddb04: ERR - bphdb exit status = 29: failed trying to exec a command

9/4/2012 8:17:35 PM - end writing

failed trying to exec a command(29)

9/4/2012 8:17:40 PM - Info bphdb(pid=9492) done. status: 29: failed trying to exec a command    

 

The backup script looks fine. To test, I've started a manual backup on the SQL server itself, backing up "master" DB, and got this from the Netbackup MSSQL Client status

OPERATION BACKUP

DATABASE "master"

SQLHOST "STARS01PRDDB04"

NBSERVER "STARS01PRDBK01"

MAXTRANSFERSIZE 6

BLOCKSIZE 7

BROWSECLIENT "STARS01PRDDB04"

NUMBUFS 2

SQLCOMPRESSION TRUE

ENDOPER TRUE

 

ERR - Error in CDBbackrec::CDBbackrec: 6.

    CONTINUATION: - The system cannot find the file specified.

ERR - Error in VxBSASetEnv(NBBSA_CLIENT_HOST): 6.

    CONTINUATION: - The handle used to associate this call with a previous VxBSAInit() call is invalid.

INF - Results of executing <D:\Program Files\Veritas\NetBackup\dbext\mssql\temp\__18_32_37_614_00.bch>: 

<0> operations succeeded. <1> operations failed.

INF - The following object(s) were not backed up successfully.

INF - master