SQL Backup Failing in netbackup 6.5

[araj]

Dear Team,

Can you please provide me a solution for the below mentioned error

We have started backup but getting error “none of the requested files were backed up(2)”.while backuping up SQL Database in Netbackup 6.5

If you have faced this issue please revert back .

Regards,

Allwyn Raj
araj@mielesecurity.com

[Andy_Welburn · Accepted solution]

Most common issues and solutions to NetBackup for SQL backups that fail with Status Code 2.
http://seer.entsupport.symantec.com/docs/334935.htm

[ayodeji]

can i see your backup selection. if it is wrong, it might cause this error to happen

[shankar369]

This problem will occur due to firewall also, can you please check the Ports 13782 , 13720 and 13724 should be opened both bi-directional.
http://seer.entsupport.symantec.com/docs/278718.htm

[Marianne]

The TechNote that Andy mentioned is the best that I've seen for troubleshooting SQL backup errors. Status 2 is the generic code for SQL agent backup failures.

This is how the TechNote starts:

Analyzing over 500 SQL cases, almost 80% of the cases are opened because of a Status Code 2 being returned by a failed backup:

38 % due to Network Name Resolution.

25% due to a corrupted batch file is, or some 25% are due to missing or incorrect mandatory parameters.

15% due to Backup Policy configuration.

Following, are troubleshooting steps divided into these areas for a SQL backup that fails with Status Code 2.

..................

MOST important log file is <install_path>\NetBackup\logs\dbclient\<date>.log.

Create the folder if it does not exist and retry the backup. Post dbclient log, please.

[Deepak_G]

Create MSSQL Backup Failures log folder under the following path

install_path \netbackup\logs\mssql_backup_failures

and then run your backup's. Report logs will get generated and that will have the details for the backup failure.