SQB service did not acknowledge receipt of data

duanemahon

Getting error when database backups run:
From running command:

EXEC master..sqlbackup '-sql "BACKUP DATABASE model TO DISK = [c:\model.sqb] WITH INIT"'

SQL Backup v4.6.0.815
ERRSQB: 5240 (SQB service did not acknowledge receipt of data. (WAIT_TIMEOUT)) ()

(1 row(s) affected)

name|value
exitcode|5240
sqlerrorcode|0

(2 row(s) affected)

Jason Cook

When the backup command was run, a log should have been generated in the following folder:

C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\%instance_name%where %instance_name% is the name of the instance, or "(local)" for the default instance.

If you could post the corresponding log file relating to that backup, we can give more information as to what may be causing the issue.

Thanks,
Jason

duanemahon

I had solved the issue with the following:
From: Peter Yeoh [mailto:info01@yohz.com]
Sent: Monday, October 29, 2007 11:10 AM
To: Duane Mahon
Subject: Re: ERRSQB: 5240 (SQB service did not acknowledge receipt of data. (WAIT_TIMEOUT)) ()


Hi,

Sorry, I'm not on AOL.

We need to remove the Global\SQBMutex_ object. It would be better if you could reboot the system to get it into a clean state before attempting to debug. If that is not possible, we can remove the object forcibly. To do that, please download Process Explorer from here: http://www.microsoft.com/technet/sysint ... lorer.mspx

Start it. Using the Find item from the menu, look for SQBMutex_. The list of processes holding a handle to that object would be listed. Double click on the object. The processs' list of objects is displayed, including the SQBMutex_ object. Right click, and select 'Close Handle' to remove the object. Then try starting the SQL Backup Agent again.


Peter Yeoh
Developer
Red Gate Software Ltd