Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQL Backup is failing with error code 6

Created: 04 Aug 2014 • Updated: 12 Aug 2014 | 7 comments
This issue has been solved. See solution.

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

Operating Systems:

Comments 7 CommentsJump to latest comment

ChAmp35's picture

Hi

kindly provide the netbackup version & SQL version.

also dbclient logs from the SQL host

Marianne's picture

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.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

SOLUTION
Ranjth-Acc's picture

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's picture

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?

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Pangal's picture

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

gurminder singh's picture

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's picture

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