Backup Jobs Hanging

• 
  Which version of SQL Backup are you running?
  
  Thanks,
  
  - James

  James Moore May 06, 2007 12:58

  - 0 +
• 
  4.6.0.815

  qsac226 May 08, 2007 10:52

  - 0 +
• 
  I'm having this problem as well and I'm using the same version. It seems to only be happening on differential and full backup jobs though. My tlogs seem to run just fine.
  
  I currently have the jobs setup as follows:
  
  TLogs - every 15mins
  Differential - every 3 hours
  Full - every night
  
  Does it matter that the jobs overlap each other?

  panderson June 05, 2007 11:37

  - 0 +
• 
  Would you guys be willing to run a debug version of SQL Backup that can help us to identify where exactly the process has hung? Backups and processes will run unchanged. The only addition is an extra function that will tell us what each SQL Backup thread is doing.
  
  Overlapping jobs should just cause the later job to reattempt a 2nd backup. E.g.
  
  - full backup starts at 1 a.m., takes 35 minutes
  - log backup starts at 1:15 a.m
  - log backup is blocked until 1:35, reports a failure, then reattempts the backup

  petey June 11, 2007 01:23

  - 0 +
• 
  Hi Peter,
  
  I seem to be experiencing a similar problem with backups hanging at random. I am running SQL Backup 4.6.0.815 Professional on on many different OS's and versions of SQL, both 32 and 64 Bit with both 32 and 64 bit editions of SQL Server.
  
  I don't seem to be able to recover from these issues until i restart the sqlbackup agent.
  
  Michelle

  michellem33 July 11, 2007 21:01

  - 0 +
• 
  We found an issue with the MAILTO function in version 4.x, that may cause SQL Backup to hang, when the mail server does not respond/process SMTP commands in a timely fashion. Are you using the MAILTO option in your backups?

  petey July 11, 2007 21:19

  - 0 +
• 
  HI Peter,
  
  We aren't using the mailto command

  michellem33 July 11, 2007 21:51

  - 0 +
• 
  Hi An example of the The command we are running (taken from the redgate logfiles directory) is:
  
  
  12/07/2007 10:48:19 AM: BACKUP DATABASE [DBNAME] TO DISK = 'g:\backup\DBNAME\DBNAME_db_200707121048.BAK.SQB' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', ERASEFILES = 2, COMPRESSION = 3

  michellem33 July 11, 2007 22:12

  - 0 +
• 
  Could you pls download a debug version of SQL Backup from http://www.yohz.com/downloads/sqb4_6_debug.zip?
  
  In that archive, you will find SQBCoreService.exe and xp_sqlbackup.dll for Win32 and x64 platforms. Please replace the existing copies of the above files on a server that encounters the hanging issue most frequently. The xp_sqlbackup.dll file needs to be placed in the SQL Server Binn folder. You may need to unload the DLL from SQL Servers' memory space first, using
  

  DBCC xp_sqlbackup(FREE)
  

  The next time that a backup hangs, run the following from Query Analyzer/SSMS:
  

  EXEC master..sqbutility 9997
  

  This will generate a file named SQBCoreService_bugreport.txt in the SQL Backup folder. Send me that file. Thanks.

  petey July 11, 2007 22:44

  - 0 +
• 
  thanks peter. I have installed on three servers experiencing the problem and will send you the output when/if it happens again.

  michellem33 July 11, 2007 23:37

  - 0 +

Add comment

Please sign in to leave a comment.