cancel
Showing results for 
Search instead for 
Did you mean: 

none of the requested files were backed up(2)

TontonAMA
Level 2

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)

3 ACCEPTED SOLUTIONS

Accepted Solutions

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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

View solution in original post

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
" GROUPSIZE cannot be specified after the first operation."

Please show us your script.

View solution in original post

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

View solution in original post

6 REPLIES 6

Dr_Ennui
Level 3

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
Moderator
Moderator
Partner    VIP    Accredited Certified

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

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
" GROUPSIZE cannot be specified after the first operation."

Please show us your script.

TontonAMA
Level 2

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

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)