Problem win sql backup

[O-a]

Hi

I'm having a problem with sql backup on one of my sql servers.

i backup with netbackup 6.5.6 .the server is 2003 with sql 2005 std.

The status code i'm getting is 2.

I checked the *.bck file on the C:\Program Files\Veritas\NetBackup\DbExt\MsSql and its look ok.

I tried to ununstall / install the client but it didnt worked.

on the logs\bpcd folder i'm getting this log:

11:41:01.421 [2680.4488] <2> bpcd main: offset to GMT -7200
11:41:01.421 [2680.4488] <2> bpcd main: Got socket for input 528
11:41:01.421 [2680.4488] <2> logconnections: BPCD ACCEPT FROM192.168.1.82.4775 TO192.168.1.8.13724
11:41:01.421 [2680.4488] <2> bpcd main: setup_sockopts complete
11:41:01.437 [2680.4488] <2> bpcd peer_hostname: Connection from hostbackupsrv (10.10.1.82) port 4775
11:41:01.437 [2680.4488] <2> bpcd valid_server: comparing Backupsrv andbackupsrv
11:41:01.453 [2680.4488] <4> bpcd valid_server: hostname comparison succeeded
11:41:01.468 [2680.4488] <2> bpcd main: output socket port number = 1
11:41:01.937 [2680.4488] <2> bpcd main: Duplicated vnetd socket on stderr
11:41:01.937 [2680.4488] <2> bpcd main: <---- NetBackup 6.5 0 ------------initiated
11:41:01.937 [2680.4488] <2> bpcd main: VERBOSE = 0
11:41:01.937 [2680.4488] <2> bpcd main: Not using VxSS authentication withbackupsrv
11:41:02.140 [2680.4488] <2> bpcd main: BPCD_DISCONNECT_RQST
11:41:02.140 [2680.4488] <2> bpcd exit_bpcd: exit status 0  ----------->exiting
11:41:03.531 [3976.6064] <2> bpcd main: offset to GMT -7200
11:41:03.531 [3976.6064] <2> bpcd main: Got socket for input 500
11:41:03.531 [3976.6064] <2> logconnections: BPCD ACCEPT FROM192.168.1.82.4783 TO192.168.1.8.13724
11:41:03.531 [3976.6064] <2> bpcd main: setup_sockopts complete
11:41:03.546 [3976.6064] <2> bpcd peer_hostname: Connection from hostbackupsrv (10.10.1.82) port 4783
11:41:03.546 [3976.6064] <2> bpcd valid_server: comparing Backupsrv andbackupsrv
11:41:03.546 [3976.6064] <4> bpcd valid_server: hostname comparison succeeded
11:41:03.546 [3976.6064] <2> bpcd main: output socket port number = 1
11:41:04.015 [3976.6064] <2> bpcd main: Duplicated vnetd socket on stderr
11:41:04.015 [3976.6064] <2> bpcd main: <---- NetBackup 6.5 0 ------------initiated
11:41:04.015 [3976.6064] <2> bpcd main: VERBOSE = 0
11:41:04.015 [3976.6064] <2> bpcd main: Not using VxSS authentication withbackupsrv
11:41:04.218 [3976.6064] <2> bpcd main: BPCD_FORK_CMD_RQST
11:41:04.234 [3976.6064] <2> bpcd main: fork cmd = /usr/openv/netbackup/bin/bphdb bphdb -sb -rdbms sql_server -S backupsrv -to 3600 -c 1 -s Daily_1 -clnt mtlsrv -FULL -kl 28 -b mtlsrv_1293442861 -jobid 176345
11:41:04.234 [3976.6064] <2> bpcd main: filter type = -1
11:41:04.234 [3976.6064] <2> bpcd main: Convert args to CreateProcess format
11:41:04.234 [3976.6064] <2> bpcd main: Done converting args to CreateProcess format
11:41:04.234 [3976.6064] <2> bpcd main: new fork cmd = C:\Program Files\Veritas\NetBackup\bin\bphdb.exe -sb -rdbms sql_server -S backupsrv -to 3600 -c 1 -s Daily_1 -clnt mtlsrv -FULL -kl 28 -b mtlsrv_1293442861 -jobid 176345
11:41:04.234 [3976.6064] <2> bpcd main: Before CreateProcess
11:41:04.234 [3976.6064] <2> bpcd main: StdOutput assigned the value STDOUTSOCK
11:41:04.234 [3976.6064] <2> bpcd main: final fork cmd = "C:\Program Files\Veritas\NetBackup\bin\bphdb.exe" -sb -rdbms sql_server -S backupsrv -to 3600 -c 1 -s Daily_1 -clnt mtlsrv -FULL -kl 28 -b mtlsrv_1293442861 -jobid 176345
11:41:04.250 [3976.6064] <2> bpcd main: After CreateProcess, pid = 5812
11:41:04.250 [3976.6064] <2> bpcd exit_bpcd: exit status 0  ----------->exiting
11:44:03.406 [5756.3000] <2> bpcd main: offset to GMT -7200
11:44:03.406 [5756.3000] <2> bpcd main: Got socket for input 520
11:44:03.406 [5756.3000] <2> logconnections: BPCD ACCEPT FROM192.168.1.82.1352 TO192.168.1.8.13724
11:44:03.406 [5756.3000] <2> bpcd main: setup_sockopts complete
11:44:03.406 [5756.3000] <2> bpcd peer_hostname: Connection from hostbackupsrv (10.10.1.82) port 1352
11:44:03.406 [5756.3000] <2> bpcd valid_server: comparing Backupsrv andbackupsrv
11:44:03.406 [5756.3000] <4> bpcd valid_server: hostname comparison succeeded
11:44:03.406 [5756.3000] <2> bpcd main: output socket port number = 1
11:44:03.937 [5756.3000] <2> bpcd main: Duplicated vnetd socket on stderr
11:44:03.937 [5756.3000] <2> bpcd main: <---- NetBackup 6.5 0 ------------initiated
11:44:03.937 [5756.3000] <2> bpcd main: VERBOSE = 0
11:44:03.937 [5756.3000] <2> bpcd main: Not using VxSS authentication withbackupsrv
11:44:04.171 [5756.3000] <2> bpcd main: BPCD_GET_VERSION_RQST
11:44:04.484 [5756.3000] <2> bpcd main: BPCD_GET_VERSION_RQST
11:44:04.703 [5756.3000] <2> bpcd main: BPCD_READ_USERS_CONFIG_RQST
11:44:04.921 [5756.3000] <2> bpcd main: BPCD_GET_VERSION_RQST
11:44:05.140 [5756.3000] <2> bpcd main: BPCD_READ_HOST_CONFIG_RQST
11:44:05.359 [5756.3000] <2> bpcd main: BPCD_DISCONNECT_RQST
11:44:05.359 [5756.3000] <2> bpcd exit_bpcd: exit status 0  ----------->exiting
 

 can anyone have new ideas?

thanks for the help.

[Anonymous]

To check status codes and troubleshhooting you can refer to the table of codes here:

http://www.symantec.com/docs/TECH58686

From here there is a techdoc for most common SQL backup problems amongst others and steps to solve if get Status 2

Analyzing over 500 SQL cases, almost 80% of the cases are opened because of a Status Code 2 being returned by a failed backup:
 

38 % due to Network Name Resolution.
 

25% due to a corrupted batch file is, or some 25% are due to missing or incorrect mandatory parameters.
 

15% due to Backup Policy configuration.

http://www.symantec.com/docs/TECH75456

[RiaanBadenhorst]

Hi,

Please post the dbclient log from the SQL client.