SQL backup policy fail with status 2

[ahmed_gad1]

i got SQL backup policy to backup database . today it didn't run successfully although the communication between master server ans client is ok.

below is the job status from the activity monitor:

/27/2014 8:18:16 AM - Info nbjm(pid=5884) starting backup job (jobid=322285) for client EBCACHDB1, policy ACH_SQL_Core_LOG, schedule LOG  
6/27/2014 8:18:16 AM - Info nbjm(pid=5884) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=322285, request id:{91498EAA-7EE5-4FB6-A155-5B0DFC7F22C8})  
6/27/2014 8:18:16 AM - requesting resource ebc-netbackup-hcart-robot-tld-0
6/27/2014 8:18:16 AM - requesting resource ebc-netbackup.NBU_CLIENT.MAXJOBS.EBCACHDB1
6/27/2014 8:18:16 AM - requesting resource ebc-netbackup.NBU_POLICY.MAXJOBS.ACH_SQL_Core_LOG
6/27/2014 8:18:16 AM - granted resource ebc-netbackup.NBU_CLIENT.MAXJOBS.EBCACHDB1
6/27/2014 8:18:16 AM - granted resource ebc-netbackup.NBU_POLICY.MAXJOBS.ACH_SQL_Core_LOG
6/27/2014 8:18:16 AM - granted resource ebc-netbackup-hcart-robot-tld-0
6/27/2014 8:18:16 AM - estimated 0 Kbytes needed
6/27/2014 8:18:16 AM - Info nbjm(pid=5884) started backup (backupid=EBCACHDB1_1403849896) job for client EBCACHDB1, policy ACH_SQL_Core_LOG, schedule LOG on storage unit ebc-netbackup-hcart-robot-tld-0
6/27/2014 8:18:17 AM - started process bpbrm (5720)
6/27/2014 8:18:18 AM - Info bpbrm(pid=5720) EBCACHDB1 is the host to backup data from     
6/27/2014 8:18:18 AM - Info bpbrm(pid=5720) reading file list from client        
6/27/2014 8:18:18 AM - connecting
6/27/2014 8:18:21 AM - Info bpbrm(pid=5720) starting bphdb on client         
6/27/2014 8:18:21 AM - connected; connect time: 00:00:03
6/27/2014 8:18:22 AM - Info bphdb(pid=6664) Backup started           
6/27/2014 8:18:44 AM - Error bpbrm(pid=5720) from client EBCACHDB1: ERR - command failed: none of the requested files were backed up (2)
6/27/2014 8:18:44 AM - Error bpbrm(pid=5720) from client EBCACHDB1: ERR - bphdb exit status = 2: none of the requested files were backed up       
6/27/2014 8:18:46 AM - end writing
none of the requested files were backed up(2)

[RamNagalla]

Does it ever successfully backup?

post the dbcliet log and bch file from the SQL host

and what are the Netbackup versions and OS vesion ans SQL version ?

[Olivier30]

Hi

Did you launch restore from BAR or from SQL dedicaced GUI ?

Olivier

[ahmed_gad1]

yes, it's daily running policy working from a long time and it fails only today.

SQL version: SQL 2008 SP3

O.S: Windows 2008-IA64

Netbackup version: 7.1.0.3

the client is connected successfully from the Netbackup console as shown in the attached screen shot.

very important note: other SQL backup policy on the same server have run successfully today.

i will post the log in my next comment.

[Mark_Solutions]

On the client take a look under \netbackup\logs\mssql_backup_failures\ to see if it has logged the errors - if so please post the log (or take a look to see why it failed as they are pretty good!)

Also look under \netbackup\logs\user_ops\dbext\logs\ for similar logs

SQL logs tend to be pretty good in explaining why the backups failed

[ahmed_gad1]

here is the dbclient log file

and to correct: the SQL version is:  2008 Enterprise x64 SP2 clustered

[Mark_Solutions]

Cannot find the file specified --- sounds like either SQL is not running or something has changed but NetBackup cannot contact SQL at all by the looks of it.

Either that or someone has turned on the firewall / DNS is messed up

[Mark_Solutions]

or... as it is clustered .. it has failed over and you have not configured the NBU SQL GUI authentication on both nodes.

[Marianne]

As a matter of interest - is "OLTPSQL2K8" the node name or the virtual name for the clustered SQL Instance?

If physical nodename, has the Instance maybe failed over to the other node?

Clustered backups should always be taken with Virtual hostname, not nodenames.

PS:
This is not the dbclient log. Please ensure that dbclient folder exists under netbackup\logs on the active node.

It will give additional info that is not in the user_ops log.

[ahmed_gad1]

There is nothing wrong with Cluster naming, this  backup policy has been running for months and the cluster configuration haven't changed at all.

i can't find at the SQL server side a log folder called "dbclient". it is not existed under Netbackup installation folder.

the firewall is off on all servers (master and client).

[Mark_Solutions]

create the dbclient folder under netbackup\logs\ then re-run th ebackup and post the logs (as an attachment)

Thanks

[Marianne]

There is nothing wrong with Cluster naming

My question was:

As a matter of interest - is "OLTPSQL2K8" the node name or the virtual name for the clustered SQL Instance?