cancel
Showing results for 
Search instead for 
Did you mean: 

SQL DB backup is failing with status (2) none of the requested files were backed up

Mallek
Level 4
Partner

Please guide on below issue if some one has faced it.

client : ERR - exit status: <2>
client : ERR - bphdb exit status = 2: none of the requested files were backed up
status: 2: none of the requested files were backed up.

Dbclient logs:

init_connect_recs: [vnet_connect.c:829] init_remote_connect_recs() failed 6 0x6
connect_to_service: [vnet_connect.c:570] init_connect_recs() failed 6 0x6
vnet_connect_to_service: [vnet_connect.c:237] connect_to_service() failed 6 0x6
bprd_connect: vnet_connect_to_service() failed: 6
bprd_get_features: bprd_connect() failed, cannot connect on socket (25)
bsa_checkFeatureId: unable to check if feature <33> is licensed
bsa_checkFeatureId: Server exit status = 25: cannot connect on socket
VxBSAInit: ERR - The license for the requested feature is not available.

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
File-level backup is different. Here media server connects to client.
For db backup, a connection is iniated from the client to bprd on the master.

Please do the following:
Ensure bprd log folder exists on the master server. If not, create the folder and restart NBU.

Run this command on the client:
bpclntcmd -pn

Please post output from command.
Also check bprd log to see if connection is received from client IP address/name.

View solution in original post

7 REPLIES 7

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
Just giving us the error and dbclient snippet does not help.

We neex to see where the client is trying to connect to bprd (via PBX) to the master server.

You need to verify comms between master and SQL client.
Check forward and reverse name lookup as well as port connectivity in both directions on port 1556 (PBX).

Thiago_Ribeiro
Moderator
Moderator
Partner    VIP    Accredited

Hi @Mallek,

Can you run the troubleshooting below?

https://www.veritas.com/support/en_US/article.TECH141839

 

Regards,

 

Thiago

Hi 

Thanks much Thiago_Ribeiro for sharing this valuable technote. 

We have check all steps.

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
File-level backup is different. Here media server connects to client.
For db backup, a connection is iniated from the client to bprd on the master.

Please do the following:
Ensure bprd log folder exists on the master server. If not, create the folder and restart NBU.

Run this command on the client:
bpclntcmd -pn

Please post output from command.
Also check bprd log to see if connection is received from client IP address/name.

Mystre316
Level 4

Check that Netbackup has permissions to connect to/backup SQL ask well. Ask DBAs to use the sql client to test a backup of a DB.

NBU35
Level 6

These are errors which immediately points towards name resolution issues.

Lets start from Basics.

1) first make sure, bptestbpcd -client client_ name should run from master/media for each and every interface of client and it should complete successfully, if it fails then check which IP and interface is creating issue, make entry of that interface in host file of master/media server. Alos check with bpclntcmd command, if client is able to resolve each and every interface of Master/media server.

2) account used for netbackup for SQL must have bulitinadmin privilages and SQL SYSadmin privilages, Netbackup client services & NetBackup legacy network service must be started with this user.

3) Try to execute script from client, sql for netbackup > file > manage scripts, if this works then, there must be some issue with permissions of your user.

also share dbclient & bpcd logs from client.