Forum Discussion

Mallek's avatar
Mallek
Level 4
8 years ago

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

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.

7.7
windows server 2012
  • Marianne's avatar
    Marianne
    8 years ago
    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.
  • Marianne's avatar
    Marianne
    Level 6
    8 years ago
    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).
    • Mallek's avatar
      Mallek
      Level 4
      8 years ago

      Hi 

    • Mallek's avatar
      Mallek
      Level 4
      8 years ago

      Thanks much Thiago_Ribeiro for sharing this valuable technote. 

      We have check all steps.

      • Marianne's avatar
        Marianne
        Level 6
        8 years ago
        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's avatar
    Mystre316
    Level 4
    8 years ago

    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's avatar
    NBU35
    Level 6
    8 years ago

    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.