One job failing on first try every day

[bfogliano]

We are running Netbackup 7.0.1 and I am having an issue with one policy.  Every day on one server the Default Application backup for one policy fails one time and then passes on the next consistently for about two weeks now.  I have checked the event viewer log files on the backup server and really don't see much, when I look at the application log files on the client server I do see the error message for each days failed backup, but the description really doesn't tell me much other than to check the logs on the backup server which doesn't tell me much.  Does this sound familiar to anyone?  Could this be a scheduling problem?  Any thoughts would be greatly appreciated.  Also this server is a Windows 2003 machine if that is of any matter.

Thanks again.

[sri_vani]

what kind of backup it is?flat file ?db backup?ndmp?

What is the error messsage you are getting?what did u see in bppbkar logs?

[bfogliano]

The backup type is a default application backup, the error message is a 6 stating that if failed to backup the selected files when i run bperror and the server name in the logs this comes up for the part where it fails is

1339114161 1 4 4 srlb1tbx02 612849 612849 0 srrb6avsql nbjm started backup job f
or client srrb6avsql, policy SRRB6AVSQL_SQL, schedule Default-Application-Backup
 on storage unit srlb1tbx02-hcart3-robot-tld-0
1339114162 1 4 4 srlb1tbx02 612849 612849 0 srrb6avsql nbjm client srrb6avsql ha
ndling path /SRRB6AVSQL.MSSQL7.SRRB6AVSQL.db.ReportStore.~.7.001of001.2012060720
0914..C
1339114186 1 388 4 srlb1tbx02 612849 612849 0 srrb6avsql bptm begin writing back
up id srrb6avsql_1339114161, copy 1, fragment 1, to media id 000087 on drive IBM
.ULTRIUM-TD3.005 (index 5)
1339114202 1 4 32 srlb1tbx02 612849 612849 0 srrb6avsql bptm attempted to write
0 gigabytes, 6168 bytes, it is not a multiple of 512
1339114207 1 4 4 srla4tbx01 612850 612850 0 srrb6avsql nbjm started backup job f
or client srrb6avsql, policy SRRB6AVSQL_SQL, schedule Default-Application-Backup
 on storage unit srla4tbx01-hcart3-robot-tld-0
1339114207 1 4 4 srla4tbx01 612850 612850 0 srrb6avsql nbjm client srrb6avsql ha
ndling path /SRRB6AVSQL.MSSQL7.SRRB6AVSQL.db.SecurityStore.~.7.001of001.20120607
201000..C
1339114209 1 68 4 srlb1tbx02 612849 612849 0 srrb6avsql nbpem CLIENT srrb6avsql
 POLICY SRRB6AVSQL_SQL  SCHED Default-Application-Backup  EXIT STATUS 6 (the bac
kup failed to back up the requested files)
1339114209 1 4 16 srlb1tbx02 612849 612849 0 srrb6avsql nbpem backup of client s
rrb6avsql exited with status 6 (the backup failed to back up the requested files
)

I tried to run the bppbkar command but it would not recognize it.  Thanks for your help

[Will_Restore]

C:\Program Files\Veritas\NetBackup\logs\mssql_backup_failures

Status 6 is generic database backup failure.  The corresponding .rpt file in the directory mentioned above should provide clue as what is really going on. 

[bfogliano]

I really appreciate the help but I don't have a directory mssql_backup_failures and the logs themselves have numbers I tried to open a few but they are huge and very hard to read.  I tried this from the command line and drilling down through Explorer.  Thanks again.

[Will_Restore]

and run the job again 

[Marianne]

Please also create dbclient log on SQL client.

Post dbclient and  mssql_backup_failures log after next failure as attachments.

[bfogliano]

Hey sorry it has been so long for my reply, thank you all for your help it appears that the issue involved the SAN drive getting dropped off repeatedly.  The issue was resolved and the backup works on the first attempt now. 

I do have another question though, when restoring a Lotus Notes .nsf file, if I do not want to replace the original file but restore a file to another location, do I need to create a new instance ID for the mail file? 

Any comments greatly appreciated.

Thanks

Brandon

[Will_Restore]

Lotus Notes restore is covered in the Admin Guide

http://www.symantec.com/business/support/index?page=content&id=DOC3668

Please open new thread if you have further questions with that.