08-04-2014 04:47 AM
Hello Everyone,
SQL backup is failing with error code 6. Please find the attached script and policy details. SQL backup is configured on the cluster name.
Below is the script details,
OPERATION BACKUP
DATABASE $ALL
SQLHOST "***SSQL"
NBSERVER "SLNX-NBUMST-LONSRD-PROD.ESC.LON.DLH.DE"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "***scluster-bpg.uk.tcgdns.com"
NUMBUFS 2
VDITIMEOUTSECONDS 1800
ENDOPER TRUE
Regards,
Ranjith P
Solved! Go to Solution.
08-04-2014 05:38 AM
SQL policy deactivated? Why is 'Active' showing 'no'?
Policy Name: MSSQLbackTOPICSCLUSTER Policy Type: MS-SQL-Server Active: no
Have you verified port connectivity (vnetd - 13724) and forward and reverse name lookup in all directions?
Master <-> virtual hostname
Media server <-> virtual hostname
Have you verified that NBU Client service on cluster nodes is started as SQL admin with local admin rights as well as SQL rights?
For further troubleshooting, we will need dbclient log on active SQL node as well as bprd log on the master.
08-04-2014 05:16 AM
Hi
kindly provide the netbackup version & SQL version.
also dbclient logs from the SQL host
08-04-2014 05:38 AM
SQL policy deactivated? Why is 'Active' showing 'no'?
Policy Name: MSSQLbackTOPICSCLUSTER Policy Type: MS-SQL-Server Active: no
Have you verified port connectivity (vnetd - 13724) and forward and reverse name lookup in all directions?
Master <-> virtual hostname
Media server <-> virtual hostname
Have you verified that NBU Client service on cluster nodes is started as SQL admin with local admin rights as well as SQL rights?
For further troubleshooting, we will need dbclient log on active SQL node as well as bprd log on the master.
08-04-2014 06:39 AM
Hi Marianne thanks for the quick response. Port connectivity is fine and also servcies running with SQL admin and local admin rights.
Will provide the logs shortly. I have one quick query. In the script
SQLHOST "***SSQL" and BROWSECLIENT "***scluster-bpg.uk.tcgdns.com" both are different.
Is this causing any issue?
08-04-2014 06:51 AM
If memory serves me right, the 2 names should be the same:
SQLHOST "VIRTUAL-SQL"
NBSERVER "MASTER-NAME"
BROWSECLIENT "VIRTUAL-SQL"
In addition to port connectivity, have you verified forward and reverse name lookup in all directions?
About status 6 - is this the parent job?
Any child jobs generated?
08-04-2014 07:34 AM
YES SQLHOST AND BROWSECLIENT NAME SHOULD BE SAME i.e. virtual sql
08-04-2014 09:17 AM
Could you please also advise, As per the Marina mentioend in the above comments, why Active is showing as No for the policy.
08-12-2014 01:30 AM
Hi All. Thanks for your help. Issue has been resolved.