Forum Discussion

TontonAMA's avatar
TontonAMA
Level 2
8 years ago

none of the requested files were backed up(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)

7.6
  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    8 years ago

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

  • Marianne's avatar
    Marianne
    8 years ago
    " GROUPSIZE cannot be specified after the first operation."

    Please show us your script.
  • Marianne's avatar
    Marianne
    8 years ago

    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.

  • Dr_Ennui's avatar
    Dr_Ennui
    Level 3
    8 years ago

    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's avatar
    RiaanBadenhorst
    Level 6
    8 years ago

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

  • Marianne's avatar
    Marianne
    Level 6
    8 years ago
    " GROUPSIZE cannot be specified after the first operation."

    Please show us your script.
    • Marianne's avatar
      Marianne
      Level 6
      8 years ago

      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's avatar
        TontonAMA
        Level 2
        8 years ago

        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)