06-30-2015 09:28 AM
hi all please i have a issue with a backup for sql on netbackup 7.6
30 juin 2015 16:07:50 - Info nbjm (pid=9181) starting backup job (jobid=128150) for client argn8001, policy nbusql, schedule sqlbckfulldaily
30 juin 2015 16:07:50 - Info nbjm (pid=9181) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=128150, request id:{281E260A-1F42-11E5-9D56-786635750159})
30 juin 2015 16:07:50 - requesting resource studskfile
30 juin 2015 16:07:50 - requesting resource netbserver.NBU_CLIENT.MAXJOBS.argn8001
30 juin 2015 16:07:50 - requesting resource netbserver.NBU_POLICY.MAXJOBS.nbusql
30 juin 2015 16:07:50 - granted resource netbserver.NBU_CLIENT.MAXJOBS.argn8001
30 juin 2015 16:07:50 - granted resource netbserver.NBU_POLICY.MAXJOBS.nbusql
30 juin 2015 16:07:50 - granted resource studskfile
30 juin 2015 16:07:50 - estimated 0 kbytes needed
30 juin 2015 16:07:50 - Info nbjm (pid=9181) started backup (backupid=argn8001_1435680470) job for client argn8001, policy nbusql, schedule sqlbckfulldaily on storage unit studskfile
30 juin 2015 16:07:51 - Info bpbrm (pid=27102) argn8001 is the host to backup data from
30 juin 2015 16:07:51 - started process bpbrm (pid=27102)
30 juin 2015 16:07:51 - connecting
30 juin 2015 16:07:51 - Info bpbrm (pid=27102) reading file list for client
30 juin 2015 16:07:52 - Info bpbrm (pid=27102) starting bphdb on client
30 juin 2015 16:07:52 - Info bphdb (pid=7124) Backup started
30 juin 2015 16:07:52 - Info dbclient (pid=6668) USER - A batch file that uses <DATABASE $ALL>, <FILEGROUPS $ALL>, or <FILES $ALL> must specify exactly one operation.
30 juin 2015 16:07:52 - Info dbclient (pid=6668) INF - Results of executing <C:\Program Files\Veritas\NetBackup\dbext\mssql\full_db_backup.bch>:
30 juin 2015 16:07:52 - Info dbclient (pid=6668) <0> operations succeeded. <0> operations failed.
30 juin 2015 16:07:52 - connected; connect time: 0:00:00
30 juin 2015 16:08:12 - Error bpbrm (pid=27102) from client argn8001: ERR - command failed: none of the requested files were backed up (2)
30 juin 2015 16:08:12 - Error bpbrm (pid=27102) from client argn8001: ERR - bphdb exit status = 2: none of the requested files were backed up
30 juin 2015 16:08:13 - Info bphdb (pid=7124) done. status: 2: none of the requested files were backed up
30 juin 2015 16:08:13 - end writing
none of the requested files were backed up (2)
Solved! Go to Solution.
06-30-2015 09:40 AM
30 juin 2015 16:07:52 - Info dbclient (pid=6668) USER - A batch file that uses <DATABASE $ALL>, <FILEGROUPS $ALL>, or <FILES $ALL> must specify exactly one operation.
could you show us the batch file located in C:\Program files\Veritas\NetBackup\dbext\mssql\full_db_backup.bch
06-30-2015 11:25 AM
I can see you have specified two instances in this script.
SQLINSTANCE "PAIE"
SQLINSTANCE "SQL2008"
If these are the only instances you are interested in backing up then you can remove the third part in the script.
which is
OPERATION BACKUP
DATABASE $ALL
SQLHOST "argn8001"
NBSERVER "NETBSERVER"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
POLICY nbusql
NUMBUFS 2
ENDOPER TRUE
06-30-2015 09:40 AM
30 juin 2015 16:07:52 - Info dbclient (pid=6668) USER - A batch file that uses <DATABASE $ALL>, <FILEGROUPS $ALL>, or <FILES $ALL> must specify exactly one operation.
could you show us the batch file located in C:\Program files\Veritas\NetBackup\dbext\mssql\full_db_backup.bch
06-30-2015 10:49 AM
this is full_db_backup.bch file
OPERATION BACKUP
DATABASE $ALL
SQLHOST "argn8001"
SQLINSTANCE "SQL2008"
NBSERVER "NETBSERVER"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
POLICY nbusql
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE $ALL
SQLHOST "argn8001"
SQLINSTANCE "PAIE"
NBSERVER "NETBSERVER"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
POLICY nbusql
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE $ALL
SQLHOST "argn8001"
NBSERVER "NETBSERVER"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
POLICY nbusql
NUMBUFS 2
ENDOPER TRUE
06-30-2015 11:25 AM
I can see you have specified two instances in this script.
SQLINSTANCE "PAIE"
SQLINSTANCE "SQL2008"
If these are the only instances you are interested in backing up then you can remove the third part in the script.
which is
OPERATION BACKUP
DATABASE $ALL
SQLHOST "argn8001"
NBSERVER "NETBSERVER"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
POLICY nbusql
NUMBUFS 2
ENDOPER TRUE