SQB service did not acknowledge receipt of data

duanemahonduanemahon Posts: 3
edited November 13, 2007 2:26PM in SQL Backup Previous Versions
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)

Comments

  • 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
  • I had solved the issue with the following:
    From: Peter Yeoh [mailto:[email protected]]
    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
Sign In or Register to comment.