none of the requested files were backed up(2)

[TontonAMA]

14/09/2017 11:58:04 - Info nbjm(pid=6536) starting backup job (jobid=185842) for client SRVAPP, policy BKP_SQLCBG, schedule Full_SQL
14/09/2017 11:58:04 - Info nbjm(pid=6536) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=185842, request id:{250E1B4D-8D4D-4505-9C8F-9A3832F68A87})
14/09/2017 11:58:04 - requesting resource studedupSQL
14/09/2017 11:58:04 - requesting resource srv-nbk.ad-cbg.com.NBU_CLIENT.MAXJOBS.SRVAPP
14/09/2017 11:58:04 - requesting resource srv-nbk.ad-cbg.com.NBU_POLICY.MAXJOBS.BKP_SQLCBG
14/09/2017 11:58:05 - granted resource srv-nbk.ad-cbg.com.NBU_CLIENT.MAXJOBS.SRVAPP
14/09/2017 11:58:05 - granted resource srv-nbk.ad-cbg.com.NBU_POLICY.MAXJOBS.BKP_SQLCBG
14/09/2017 11:58:05 - granted resource studedupSQL
14/09/2017 11:58:06 - estimated 0 Kbytes needed
14/09/2017 11:58:06 - Info nbjm(pid=6536) started backup (backupid=SRVAPP_1505390285) job for client SRVAPP, policy BKP_SQLCBG, schedule Full_SQL on storage unit studedupSQL
14/09/2017 11:58:06 - started process bpbrm (4880)
14/09/2017 11:58:07 - Info bpbrm(pid=4880) SRVAPP is the host to backup data from
14/09/2017 11:58:07 - Info bpbrm(pid=4880) reading file list for client
14/09/2017 11:58:07 - connecting
14/09/2017 11:58:09 - Info bpbrm(pid=4880) starting bphdb on client
14/09/2017 11:58:09 - connected; connect time: 0:00:02
14/09/2017 11:58:11 - Info bphdb(pid=5088) Backup started
14/09/2017 11:58:12 - Info dbclient(pid=6072) USER - GROUPSIZE cannot be specified after the first operation.
14/09/2017 11:58:12 - Info dbclient(pid=6072) USER - GROUPSIZE cannot be specified after the first operation.
14/09/2017 11:58:12 - Info dbclient(pid=6072) USER - A batch file that uses <DATABASE $ALL>, <FILEGROUPS $ALL>, or <FILES $ALL> must specify exactly one operation.
14/09/2017 11:58:12 - Info dbclient(pid=6072) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Full_BackupAPP.bch>:
14/09/2017 11:58:12 - Info dbclient(pid=6072) <0> operations succeeded. <0> operations failed.
14/09/2017 11:58:32 - Error bpbrm(pid=4880) from client SRVAPP: ERR - command failed: none of the requested files were backed up (2)
14/09/2017 11:58:32 - Error bpbrm(pid=4880) from client SRVAPP: ERR - bphdb exit status = 2: none of the requested files were backed up
14/09/2017 11:58:34 - Info bphdb(pid=5088) done. status: 2: none of the requested files were backed up
14/09/2017 11:58:34 - end writing
none of the requested files were backed up(2)

4/09/2017 12:08:34 - Info nbjm(pid=6536) starting backup job (jobid=185842) for client SRVAPP, policy BKP_SQLCBG, schedule Full_SQL
14/09/2017 12:08:34 - Info nbjm(pid=6536) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=185842, request id:{3CB068B0-C4D2-49B5-85B7-55378D717542})
14/09/2017 12:08:34 - requesting resource studedupSQL
14/09/2017 12:08:34 - requesting resource srv-nbk.ad-cbg.com.NBU_CLIENT.MAXJOBS.SRVAPP
14/09/2017 12:08:34 - requesting resource srv-nbk.ad-cbg.com.NBU_POLICY.MAXJOBS.BKP_SQLCBG
14/09/2017 12:08:35 - granted resource srv-nbk.ad-cbg.com.NBU_CLIENT.MAXJOBS.SRVAPP
14/09/2017 12:08:35 - granted resource srv-nbk.ad-cbg.com.NBU_POLICY.MAXJOBS.BKP_SQLCBG
14/09/2017 12:08:35 - granted resource studedupSQL
14/09/2017 12:08:35 - estimated 0 Kbytes needed
14/09/2017 12:08:35 - Info nbjm(pid=6536) started backup (backupid=SRVAPP_1505390915) job for client SRVAPP, policy BKP_SQLCBG, schedule Full_SQL on storage unit studedupSQL
14/09/2017 12:08:35 - started process bpbrm (10092)
14/09/2017 12:08:36 - Info bpbrm(pid=10092) SRVAPP is the host to backup data from
14/09/2017 12:08:36 - Info bpbrm(pid=10092) reading file list for client
14/09/2017 12:08:36 - connecting
14/09/2017 12:08:38 - Info bpbrm(pid=10092) starting bphdb on client
14/09/2017 12:08:38 - connected; connect time: 0:00:02
14/09/2017 12:08:40 - Info bphdb(pid=1836) Backup started
14/09/2017 12:08:40 - Info dbclient(pid=5848) USER - GROUPSIZE cannot be specified after the first operation.
14/09/2017 12:08:40 - Info dbclient(pid=5848) USER - GROUPSIZE cannot be specified after the first operation.
14/09/2017 12:08:40 - Info dbclient(pid=5848) USER - A batch file that uses <DATABASE $ALL>, <FILEGROUPS $ALL>, or <FILES $ALL> must specify exactly one operation.
14/09/2017 12:08:40 - Info dbclient(pid=5848) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Full_BackupAPP.bch>:
14/09/2017 12:08:40 - Info dbclient(pid=5848) <0> operations succeeded. <0> operations failed.
14/09/2017 12:09:00 - Error bpbrm(pid=10092) from client SRVAPP: ERR - command failed: none of the requested files were backed up (2)
14/09/2017 12:09:00 - Error bpbrm(pid=10092) from client SRVAPP: ERR - bphdb exit status = 2: none of the requested files were backed up
14/09/2017 12:09:02 - Info bphdb(pid=1836) done. status: 2: none of the requested files were backed up
14/09/2017 12:09:02 - end writing
none of the requested files were backed up(2)

[Dr_Ennui]

14/09/2017 11:58:12 - Info dbclient(pid=6072) USER - A batch file that uses <DATABASE $ALL>, <FILEGROUPS $ALL>, or <FILES $ALL> must specify exactly one operation.
14/09/2017 11:58:12 - Info dbclient(pid=6072) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Full_BackupAPP.bch>:
14/09/2017 11:58:12 - Info dbclient(pid=6072) <0> operations succeeded. <0> operations failed.
14/09/2017 11:58:32 - Error bpbrm(pid=4880) from client SRVAPP: ERR - command failed: none of the requested files were backed up (2)

Looks like you might need to check your SQL Backup script.

[RiaanBadenhorst · Accepted solution]

You've probably got a Full backup and transaction log backup configured in the same script. Pick one.

[Marianne · Accepted solution]

" GROUPSIZE cannot be specified after the first operation."

Please show us your script.

[Marianne · Accepted solution]

The errors in job details were really telling you what is wrong.

Put this section (transaction logs) in a separate script and create a separate policy:

OPERATION BACKUP
DATABASE $ALL
SQLHOST "SRV-APP"
NBSERVER "SRV-NBK.AD-CBG.com"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
OBJECTTYPE TRXLOG
NUMBUFS 2
ENDOPER TRUE

I also believe that you can only have one GROUPSIZE paramer in a script and must be the 1st line in the script.

[TontonAMA]

Merci pour votre support, grace a vous mes sauvegardes et restaurations SQL ont réussies !! 

19/09/2017 11:56:00 - Info bpbrm(pid=10276) reading file list for client
19/09/2017 11:56:00 - connecting
19/09/2017 11:56:02 - Info bpbrm(pid=10276) listening for client connection
19/09/2017 11:56:10 - Info bpbrm(pid=10276) INF - Client read timeout = 600
19/09/2017 11:56:11 - Info bpbrm(pid=10276) accepted connection from client
19/09/2017 11:56:11 - connected; connect time: 0:00:11
19/09/2017 11:56:11 - Info bpbrm(pid=10276) start bpbkar on client
19/09/2017 11:56:14 - Info dbclient(pid=2040) Backup started
19/09/2017 11:56:14 - Info dbclient(pid=6912) Backup started
19/09/2017 11:56:14 - Info dbclient(pid=6912) change time comparison:<disabled>
19/09/2017 11:56:14 - Info dbclient(pid=6912) archive bit processing:<enabled>
19/09/2017 11:56:14 - Info bptm(pid=12708) start
19/09/2017 11:56:23 - Info bptm(pid=12708) using 262144 data buffer size
19/09/2017 11:56:25 - Info bptm(pid=12708) setting receive network buffer to 1049600 bytes
19/09/2017 11:56:25 - Info bptm(pid=12708) using 30 data buffers
19/09/2017 11:56:46 - Info bptm(pid=12708) start backup
19/09/2017 11:57:10 - Info bptm(pid=12708) backup child process is pid 13284.13028
19/09/2017 11:57:10 - Info bptm(pid=13284) start
19/09/2017 11:57:10 - begin writing
19/09/2017 11:57:11 - Info dbclient(pid=6912) done. status: 0
19/09/2017 11:57:11 - Info bptm(pid=12708) waited for full buffer 16 times, delayed 25 times
19/09/2017 11:57:26 - Info bptm(pid=12708) EXITING with status 0 <----------
19/09/2017 11:57:26 - Info srv-nbk.ad-cbg.com(pid=12708) StorageServer=PureDisk:srv-nbk.ad-cbg.com; Report=PDDO Stats (multi-threaded stream used) for (srv-nbk.ad-cbg.com): scanned: 12732 KB, CR sent: 81 KB, CR sent over FC: 0 KB, dedup: 99.4%, cache hits: 125 (69.4%)
19/09/2017 11:57:26 - Info bpbrm(pid=10276) validating image for client SRVAPP
19/09/2017 11:57:26 - Info dbclient(pid=6912) done. status: 0: the requested operation was successfully completed
19/09/2017 11:57:26 - end writing; write time: 0:00:16
the requested operation was successfully completed(0)