09-02-2013 01:35 AM
Hi All,
We have SQL server on Windows 2008 (not R2) and SQLserver 2008 running, NetBackup is version 7.5.0.4. We did test restore after backup before successfully. Now when we tried to restore, we always encounterd a failure.
Solved! Go to Solution.
09-05-2013 12:09 AM
Hi All,
Thank your for all of your support. We resolve the problems.
Actually 2 things happened, see the solutions:
1. The brpd hung:
The restore seemed hung at 'media id needed'
It seemed that bprd process is hanging, check with bpps
# bpps -a | grep bprd
Kill the process bprd -dontfork -mpxmain with kill -9
I got the solution from:
http://www.symantec.com/connect/forums/unable-restore-data-nbu-75
http://www.symantec.com/business/support/index?page=content&id=TECH33379
2. This one is the SQL client part:
Restoration error: (cannot connect on socket)
09:02:50 (325439.002) INF - Waiting for positioning of media id 401164 on server ebs5-bck for reading.
09:03:36 (325439.002) INF - Beginning restore from server ebs5-bck to client ermapp01-bck.
09:04:05 (325439.002) Status of restore from copy 1 of image created Tue Aug 27 22:00:42 2013 = cannot connect on socket
Resolution: Within the Admin Console > Host Properties > Master > Client Attributes > Client > Browse and Restore Ability > Allow Both
Resolved the issue
(He got the solution also from the this forum too, but forgot which one)
Regards,
Iwan Tamimi
09-02-2013 05:53 AM
your clientname ermapp01-bck
please check clientserver to media server and master server connection working, check vice versa also.
please post detail logs as well. bpbrm logs will help
09-02-2013 08:31 PM
Hi rookie,
Thanks for the response, the bpbrm logs is on the client side right? I think it hasn't been created. I created then I tried again after that I post it again.
Regards,
Iwan
09-02-2013 09:39 PM
HI,
It looks some socket error “couldn't accept from data socket”. Could you check the following?
1. On your master server check move to Host Propertiesà clientsà select the your SQL server à
Right click and connect, make sure that it is able to connect.
2. Is any job is getting started on NBU activity monitor while you start from client’s BAR GUI?
Regards
Ajin
09-02-2013 10:57 PM
Ajin,
1. Yes it is enabled (see attachement).
2. No other backup running for this client.
Regards,
Iwan
09-03-2013 09:11 AM
Are you running this restore from the client itself using the NetBackup SQL GUI?
You cannot run SQL restores from the BAR Console
It does sound like a connection issue but that could be an ODBC issue is you are not running it from the right place
09-03-2013 10:13 PM
pls post dbclient log and mssql_backup_failure log from client you are performing restores.
If log dir doesnt existing create them and re-run restore job
Also post restore script (if used NBU SQL GUI instead of BAR)
09-03-2013 11:51 PM
Iwan -- bpbrm logs are on media server. media server through which restore is running
09-05-2013 12:09 AM
Hi All,
Thank your for all of your support. We resolve the problems.
Actually 2 things happened, see the solutions:
1. The brpd hung:
The restore seemed hung at 'media id needed'
It seemed that bprd process is hanging, check with bpps
# bpps -a | grep bprd
Kill the process bprd -dontfork -mpxmain with kill -9
I got the solution from:
http://www.symantec.com/connect/forums/unable-restore-data-nbu-75
http://www.symantec.com/business/support/index?page=content&id=TECH33379
2. This one is the SQL client part:
Restoration error: (cannot connect on socket)
09:02:50 (325439.002) INF - Waiting for positioning of media id 401164 on server ebs5-bck for reading.
09:03:36 (325439.002) INF - Beginning restore from server ebs5-bck to client ermapp01-bck.
09:04:05 (325439.002) Status of restore from copy 1 of image created Tue Aug 27 22:00:42 2013 = cannot connect on socket
Resolution: Within the Admin Console > Host Properties > Master > Client Attributes > Client > Browse and Restore Ability > Allow Both
Resolved the issue
(He got the solution also from the this forum too, but forgot which one)
Regards,
Iwan Tamimi