SQL server backup failing with extended error 252.

[DDS]

Net backup 6.5.2
master : AIX 5.3
Windows NT client

The SQL server backup has been failing recently with status code 252. Couldn't find anything specifi in the log entries.

Have anyone of you faced this issue?

Regards
DD

[DDS]

no replies!!! alas!!

[Taqadus_Rehman]

how much data is written till failuer? 
if logging is already enabled please check bptm and bpbkar logs

[Android]

I am now seeing the same behavior.  However the environment is at 6.5.4

[NBUTSE]

The bpbkar log won't help you with SQL backups, but you can build up the following logging directories under the netbackup/logs/ directory on the SQL server:
bpcd
bphdb
dbclient

Create those, and then go into the Backup, Archive, and Restore (BAR) gui, still on the SQL server or active SQL node.  There go to the file menu -> NetBackup client properties -> troubleshooting tab (on the right hand side).  There set the general logging level to 2, the verbose to 5, and the database to 9.  Click okay, and then close out of the BAR gui.

Now go ahead and retry the backup.

Do you see the automatic job start?

Do you see the child jobs calling back to the application-backup schedule?  Is it these jobs which are failing?

Go ahead and start with that, and then let me know if you get anywhere, what is the job's detailed status reading?  Does it report the parent process which is throwing the status 252?

-Sean