SQL backup are failing with error 23 (socket read failed )

Hi All,

File system backup are working fine but SQL backups are failing with error code 23 socket read failed .

Things i already checked:

1.I checked SQL server and netbackup client services.

2. registry entries.

pls provide me  a solution.

job detail:

02/11/2015 21:39:05 - Error bpbrm (pid=1690) bpcd on <server name> exited with status 23: socket read failed
02/11/2015 21:44:09 - Error bpbrm (pid=1690) cannot send mail because BPCD on <server name> exited with status 23: socket read failed
02/11/2015 21:44:09 - Info bpbkar (pid=0) done. status: 23: socket read failed
02/11/2015 21:44:09 - end writing
socket read failed  (23)

5 Replies

Post a snippet of the

Post a snippet of the dbclient log from the sql host between these times

21:35:00 -  21:45:00

1- Check File System backup

 

 

1- Check File System backup and SQL backup both are running on same media sever, if SQL is running from different media server, check you able to connect client by below command at media server.

 cd /usr/openv/netbackup/bin/admincmd

./bptestbpcd -client clientname

2- login into the Client server and check NB service should be running with the account which having SQL admin right.

Check on Client bpcd logs which would give more info. 

Db backup needs comms between

Db backup needs comms between master and client in addition to media server and client comms. Ensure forward and reverse name lookup between master and client as well as port connectivity on pbx (port 1556) .

Hi All , Thanks for ur

Hi All ,

Thanks for ur valuable comments.

issue has been resolved. There is name miismatch in teh regedit of client server.

 

11 Feb:  Things i already

11 Feb: 

Things i already checked:
.......

2. registry entries.

18 Feb:

issue has been resolved. There is name miismatch in teh regedit of client server.

Big eyes!! 

Next time, start with proof of the checks that have been done...