SQL Backup is failing with error code 6

[Ranjth-Acc]

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

[NBU35]

Hi

kindly provide the netbackup version & SQL version.

also dbclient logs from the SQL host

[Marianne · Accepted solution]

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.

[Ranjth-Acc]

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?

[Marianne]

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?

[Pangal]

YES SQLHOST AND BROWSECLIENT NAME SHOULD BE SAME i.e. virtual sql

[gurminder_singh]

Could you please also advise,  As per the Marina mentioend in the above comments, why Active is showing as No for the policy. 

[Ranjth-Acc]

Hi All. Thanks for your help. Issue has been resolved.