cancel
Showing results for 
Search instead for 
Did you mean: 

sql database backup ends with status 6 : backup failed to back up the requested files

hasbi
Level 2

The status of the backup as shown below:

29/6/2015 10:52:51 PM - Info nbjm(pid=7696) starting backup job (jobid=336464) for client JJHCOMVIP2, policy scomdb-sql-inc-JJHCOMVIP2, schedule Default-Application-Backup  
29/6/2015 10:52:51 PM - Info nbjm(pid=7696) requesting STANDARD_RESOURCE resources from RB for backup job (jobid=336464, request id:{376BB13C-9413-41BF-877E-2F413A059012})  
29/6/2015 10:52:51 PM - requesting resource majsmrma2-OST-stu
29/6/2015 10:52:51 PM - requesting resource majsmrfa1.NBU_CLIENT.MAXJOBS.JJHCOMVIP2
29/6/2015 10:52:51 PM - requesting resource majsmrfa1.NBU_POLICY.MAXJOBS.scomdb-sql-inc-JJHCOMVIP2
29/6/2015 10:52:51 PM - granted resource majsmrfa1.NBU_CLIENT.MAXJOBS.JJHCOMVIP2
29/6/2015 10:52:51 PM - granted resource majsmrfa1.NBU_POLICY.MAXJOBS.scomdb-sql-inc-JJHCOMVIP2
29/6/2015 10:52:51 PM - granted resource MediaID=@aaaaf;DiskVolume=OpenStorage_1;DiskPool=majsmrma2-OST-stu;Path=OpenStorage_1;StorageServer=192.168.181.247;MediaServer=majsmrma2
29/6/2015 10:52:51 PM - granted resource majsmrma2-OST-stu
29/6/2015 10:52:51 PM - estimated 0 Kbytes needed
29/6/2015 10:52:51 PM - Info nbjm(pid=7696) started backup (backupid=JJHCOMVIP2_1435589571) job for client JJHCOMVIP2, policy scomdb-sql-inc-JJHCOMVIP2, schedule Default-Application-Backup on storage unit majsmrma2-OST-stu
29/6/2015 10:52:54 PM - started process bpbrm (2104)
29/6/2015 10:53:07 PM - Info bpbrm(pid=2104) JJHCOMVIP2 is the host to backup data from     
29/6/2015 10:53:07 PM - Info bpbrm(pid=2104) reading file list for client        
29/6/2015 10:53:07 PM - connecting
29/6/2015 10:53:16 PM - Info bpbrm(pid=2104) listening for client connection         
29/6/2015 10:53:19 PM - Info bpbrm(pid=2104) INF - Client read timeout = 3600      
29/6/2015 10:53:19 PM - Info bpbrm(pid=2104) accepted connection from client         
29/6/2015 10:53:19 PM - Info dbclient(pid=7244) Backup started           
29/6/2015 10:53:19 PM - connected; connect time: 0:00:12
29/6/2015 10:53:20 PM - Info bptm(pid=8328) start            
29/6/2015 10:53:24 PM - Info bptm(pid=8328) using 262144 data buffer size        
29/6/2015 10:53:28 PM - Info bptm(pid=8328) setting receive network buffer to 1049600 bytes      
29/6/2015 10:53:28 PM - Info bptm(pid=8328) using 30 data buffers         
29/6/2015 10:53:29 PM - Info bptm(pid=8328) start backup           
29/6/2015 10:53:31 PM - Info bptm(pid=8328) backup child process is pid 2092.9212       
29/6/2015 10:53:31 PM - Info bptm(pid=2092) start            
29/6/2015 10:53:31 PM - begin writing
29/6/2015 11:23:58 PM - Info dbclient(pid=7244) done. status: 6          
29/6/2015 11:24:08 PM - Info majsmrma2(pid=8328) StorageServer=hp-StoreOnceCatalyst:192.168.181.247; Report=scanned: 1024 KB, CR sent: 541 KB, dedup: 16.41%   
29/6/2015 11:24:08 PM - Info dbclient(pid=7244) done. status: 6: the backup failed to back up the requested files 
29/6/2015 11:24:08 PM - end writing; write time: 0:30:37
the backup failed to back up the requested files(6)

1 REPLY 1

RamNagalla
Moderator
Moderator
Partner    VIP    Certified

just a detail status of faild job does not help ...

does it ever successfull?

what is the netbackup & SQL version?

please attach the dbclient log & bch file from the SQL client