restore sybase backup failed with status 2850

[shahriar_sadm]

Hi dear all, I get a successful sybase backup, for restore I want to restore individual file on client, I can browse backup in BAR, but restore failed with status code 2850

10/16/2016 14:15:43 - begin Restore
10/16/2016 14:15:44 - number of images required: 1
10/16/2016 14:15:44 - media needed: L60367
10/16/2016 14:15:45 - restoring from image SAPBISBX_1476613742
10/16/2016 14:15:47 - requesting resource L60367
10/16/2016 14:15:47 - granted resource L60367
10/16/2016 14:15:47 - granted resource HP.ULTRIUM6-SCSI.013
10/16/2016 14:16:32 - Info bpbrm (pid=23564) SAPBISBX is the host to restore to
10/16/2016 14:16:32 - Info bpbrm (pid=23564) telling media manager to start restore on client
10/16/2016 14:16:32 - Info bpbrm (pid=23564) spawning a brm child process
10/16/2016 14:16:32 - Info bpbrm (pid=23564) child pid: 23572
10/16/2016 14:16:32 - Info bpbrm (pid=23564) listening for client connection
10/16/2016 14:16:33 - Info bptm (pid=23566) Waiting for mount of media id L60367 (copy 1) on server media-nbkp-srv1.
10/16/2016 14:16:33 - started process bptm (pid=23566)
10/16/2016 14:16:33 - mounting L60367
10/16/2016 14:16:33 - Info bptm (pid=23566) INF - Waiting for mount of media id L60367 on server media-nbkp-srv1 for reading.
10/16/2016 14:17:29 - mounted L60367; mount time: 0:00:56
10/16/2016 14:17:29 - Info bptm (pid=23566) L60367
10/16/2016 14:17:29 - Info bptm (pid=23566) INF - Waiting for positioning of media id L60367 on server media-nbkp-srv1 for reading.
10/16/2016 14:17:29 - positioning L60367 to file 1
10/16/2016 14:17:29 - positioned L60367; position time: 0:00:00
10/16/2016 14:17:29 - begin reading
10/16/2016 14:17:46 - restored from image SAPBISBX_1476613742; restore time: 0:02:01
10/16/2016 14:17:47 - end Restore; elapsed time 0:02:04
10/16/2016 14:18:32 - Info bpbrm (pid=23564) media manager for backup id SAPBISBX_1476613742 exited with status 25: cannot connect on socket
10/16/2016 14:18:32 - Info bpbrm (pid=23564) terminating bpbrm child 23572 jobid=670156
10/16/2016 14:18:32 - Error bpbrm (pid=23572) listen for client protocol error - couldn't accept from data socket, No such file or directory (2)
Restore error (2850)

Also bpbrm log attached.

Thanks

[nbutech]

Hello,

Your bpbrm logs does not have the timestamp or the pid 23564 in it to look for errors

From the errors in job details 

Error bpbrm (pid=23572) listen for client protocol error - couldn't accept from data socket, No such file or directory (2)

Check technote

DB2/Informix/Oracle/SAP/SQL-Server/Sybase backup fails with status 25 if media ready occurs during client call-back
Article URL:http://www.veritas.com/docs/000007949

[Michal_Mikulik1]

Hello,

you cannot restore Sybase backups via BAR.

You must use load database command launched directly from the database client.

Regards

Michal