06-27-2014 12:26 AM
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)
06-27-2014 12:35 AM
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 ?
06-27-2014 02:06 AM
Hi
Did you launch restore from BAR or from SQL dedicaced GUI ?
Olivier
06-27-2014 02:29 AM
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.
06-27-2014 02:47 AM
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
06-27-2014 03:07 AM
here is the dbclient log file
and to correct: the SQL version is: 2008 Enterprise x64 SP2 clustered
06-27-2014 03:15 AM
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
06-27-2014 03:17 AM
or... as it is clustered .. it has failed over and you have not configured the NBU SQL GUI authentication on both nodes.
06-27-2014 03:26 AM
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.
06-27-2014 04:42 AM
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).
06-27-2014 04:46 AM
create the dbclient folder under netbackup\logs\ then re-run th ebackup and post the logs (as an attachment)
Thanks
06-27-2014 04:51 AM
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?