none of the requested files were backed up(2) and the backup failed to back up the requested files(6)

Posted on July 14, 2011

0


Today i would like to discuss a problem which i have been facing with MS SQL Server backup. Actually my SQL parent job failed with error 2 and child job failed with error 6 in the Activity Monitor.

Problem

I am taking the backup of SQl database. my parent job is failed with error 2 and child job is failed with error 6 in the Activity Monitor. i also posted both errors below for the reference.

Activity Monitor(parent job)
10/28/2009 5:06:37 PM – requesting resource TpsbdcPVCSbackup

10/28/2009 5:06:37 PM – requesting resource tpsbkp.NBU_CLIENT.MAXJOBS.tpsbdc
10/28/2009 5:06:37 PM – requesting resource tpsbkp.NBU_POLICY.MAXJOBS.Man_of_TpsBdcPVCSbackup
10/28/2009 5:06:38 PM – granted resource tpsbkp.NBU_CLIENT.MAXJOBS.tpsbdc
10/28/2009 5:06:38 PM – granted resource tpsbkp.NBU_POLICY.MAXJOBS.Man_of_TpsBdcPVCSbackup
10/28/2009 5:06:38 PM – granted resource TpsbdcPVCSbackup
10/28/2009 5:06:38 PM – estimated 0 kbytes needed
10/28/2009 5:06:38 PM – started process bpbrm (2672)
10/28/2009 5:06:51 PM – connecting
10/28/2009 5:07:03 PM – connected; connect time: 00:00:12
10/28/2009 5:14:58 PM – end writing
none of the requested files were backed up(2)Activity Monitor(Child Job)

10/28/2009 5:07:51 PM – requesting resource TpsbdcPVCSbackup
10/28/2009 5:07:51 PM – requesting resource tpsbkp.NBU_CLIENT.MAXJOBS.tpsbdc
10/28/2009 5:07:51 PM – requesting resource tpsbkp.NBU_POLICY.MAXJOBS.Man_of_TpsBdcPVCSbackup
10/28/2009 5:07:52 PM – Info nbrb(pid=3244) Limit has been reached for the logical resource tpsbkp.NBU_CLIENT.MAXJOBS.tpsbdc
10/28/2009 5:08:49 PM – granted resource tpsbkp.NBU_CLIENT.MAXJOBS.tpsbdc
10/28/2009 5:08:49 PM – granted resource tpsbkp.NBU_POLICY.MAXJOBS.Man_of_TpsBdcPVCSbackup
10/28/2009 5:08:49 PM – granted resource MediaID=@aaaay;Path=E:\Netbackup\TpsBdcPVCSbackup;MediaServer=tpsbkp
10/28/2009 5:08:49 PM – granted resource TpsbdcPVCSbackup
10/28/2009 5:08:50 PM – estimated 0 kbytes needed
10/28/2009 5:08:50 PM – started process bpbrm (5036)
10/28/2009 5:09:02 PM – connecting
10/28/2009 5:09:37 PM – connected; connect time: 00:00:35
10/28/2009 5:11:10 PM – begin writing
10/28/2009 5:13:45 PM – Error bptm(pid=5412) socket operation failed – 10054 (at child.c.1294)
10/28/2009 5:13:50 PM – Error bptm(pid=5412) unable to perform read from client socket, connection may have been broken
10/28/2009 5:15:44 PM – end writing; write time: 00:04:34
the backup failed to back up the requested files(6)

Resolution

http://seer.entsupport.symantec.com/docs/304578.htm

Advertisements