07-16-2012 07:42 AM
Hello Everyone,
I'm new here and this is my first post!! :D
I want to ask experts here about error from backup MSSQL using online agent.
I use NBU extension GUI to create backup script to full backup all DB in default instance.
When the schedule completed the parent job got status 1. Then I look for detailed page and found 1 of my DB cannot backup.
###error messages appear in Job status on NBU extention GUI ###
###cut from dbclient log###
error messages don't make any sense to me.
I tried google and KB but no work.
has anyone experience this before?
PS. sorry for my bad english.
Solved! Go to Solution.
07-16-2012 07:46 PM
Do you see similar error in application event log?
Something like this:
<16> CDBbackrec::InitDeviceSet_Part2(): ERR - Error in GetConfiguration: 0x80770003.
If so, check your task manager whether there is any leftover dbbackex.exe, kill them if there are, and re-run backup.
07-16-2012 07:59 AM
This looks like a timeout. (300 seconds = 5 minutes)
For large databases, the recommended timeout is 1800.
Increase Client Connect as well as Client Read Timeout to 1800 on the media server backing up this SQL client.
07-16-2012 08:14 AM
I have tried 900 seconds on backup script but output was same.
VDITIMEOUTSECONDS 900
I'm home now and will try 1800 seconds tomorrow.
I think DB size not big it's only 30GB.
Thanks for reply :D
07-16-2012 07:46 PM
Do you see similar error in application event log?
Something like this:
<16> CDBbackrec::InitDeviceSet_Part2(): ERR - Error in GetConfiguration: 0x80770003.
If so, check your task manager whether there is any leftover dbbackex.exe, kill them if there are, and re-run backup.
07-16-2012 08:08 PM
07-16-2012 09:07 PM
Please increase timeouts on Media Server in addtition to VDI timeout in script
We see exactly 5 minutes between last entry in dbclient log and time of failure:
10:27:30.241 [1072.6652] <2> logconnections: BPRD CONNECT FROM 192.168.121.17.59323 TO 192.168.109.100.1556 fd = 1028 10:32:30.308 [1072.6652] <4> getServerName: Read server name from nb_master_config: RSBACKUPSRV 10:32:30.308 [1072.6652] <2> vnet_pbxConnect: pbxConnectEx Succeeded 10:32:30.308 [1072.6652] <2> logconnections: BPRD CONNECT FROM 192.168.121.17.60086 TO 192.168.109.100.1556 fd = 584 10:32:30.401 [1072.6652] <16> writeToServer: ERR - send() to server on socket failed:
07-17-2012 01:11 AM
Hi Marianne.
I still got the same error even VDI timeout increased to 1800 seconds.
there are several DBBACKUP.EXE processes in task manager. I'm going endtask them all and try again.
07-17-2012 01:31 AM
PLEASE increase timeouts on MEDIA SERVER......
Before running another backup, ensure the following log folders exist on media server:
bptm and bpbrm.
If backup still fails after increasing media server timeouts, please post a new set of logs:
dbclient on SQL client, bptm and bpbrm on media server.
07-17-2012 01:47 AM
Thanks Watsons :D
It's working after I kill all of them (dbbackup.exe).
Do you know why there are leftover dbbackup.exe processes? Maybe I can prevent this to happens again in future.
07-17-2012 05:42 PM
Glad it helps.. not sure exactly why this happened, but I saw this error the other day in dbclient log in my env.:
The api was waiting and the timeout interval had elapsed.
So that's how I checked the leftover process and killed them to have it work again. I only saw that twice so far.