cancel
Showing results for 
Search instead for 
Did you mean: 

backup error sql error

Lou123
Level 3
Partner

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)

2 ACCEPTED SOLUTIONS

Accepted Solutions

RamNagalla
Moderator
Moderator
Partner    VIP    Certified

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

View solution in original post

GulzarShaikhAUS
Level 6
Partner Accredited Certified

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

 

View solution in original post

3 REPLIES 3

RamNagalla
Moderator
Moderator
Partner    VIP    Certified

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

Lou123
Level 3
Partner

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

GulzarShaikhAUS
Level 6
Partner Accredited Certified

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