I have seen SQL policy failing with status 2 with incorrect path in Backup Selection.
Please edit path and type full pathname.
I've looked at your dbclient log. This is the first error:
00:00:42.688 [10248.11152] <16> OpenParmFile: ERR - Failed trying to get read access to C:\Program Files\Veritas\NetBackup\dbext\mssql\/USNVWDBPSQL01.MSSQL7.USNVSQLDB01\CTSDB.trx.ARSystem.~.7.001of001.20140109000026..C
Please check the logon account used for NetBackup Client Service.
Best to start this service as the same account used for SQL services.
Ensure that this account has Local Admin rights on the SQL server.
Next error:
00:01:04.887 [2256.12704] <16> serverResponse: ERR - server exited with status 2: none of the requested files were backed up
00:01:04.887 [2256.12704] <16> CreateNewImage: ERR - serverResponse() failed
This means that the client tried to connect to bprd on the master server:
logconnections: BPRD CONNECT FROM 172.23.91.32.64078 TO 172.23.244.100.1556 fd = 1244
This connection attempt either never reached the master server or the something was wrong with with backup request and master server did not respond to request.
2 things to double-check:
- Port 1556 open in both directions between master an client.
- Forward and reverse hostname lookup between master and client.
Master must be able to resolve Client IP address to same hostname that appears in SQL policy. (Easiest will be to add '172.23.91.32 usnvsqldb01' to /etc/hosts on master, following by refreshing NBU host cache.)
To troubleshoot connection to master server, we need to see bprd log on the master.
If log folder does not exist, create it and restart NBU on the master.
Post bprd log after next failure.