Backup Files created even when SQLBackup errors

• 
  Thank you for your post into the forum.
  
  I maybe incorrect, I thought SQL Backup checked to ensure that there was sufficient disk space before commencing a backup task and error if the check failed.
  
  A support call has been created for you, the call reference number is F0020727. Can you please send to support@red-gate.com, 2 or 3 example SQL Backup Log Files for us to look at. If you include your call reference in the subject field of your e-mail, this will ensure that the correct call is updated.
  
  How often has this event occurred? Is it the first occurrence? Or happens intermittenly? Or every time you attempt a backup?
  
  Many Thanks
  Eddie

  Eddie D March 25, 2009 15:39

  - 0 +
• 
  Eddie,
  
  Our situation is that we had enough disk space when the jobs started but we had a number run concurrently and they used up all the disk space. I am looking at the entries for one of the failed backups and it records a Warning 210 system error 112. This is followed by an error 620, SQL error 3013, SQL error 3271 and SQL error 3202. There is a number in the compressed size. The first time the the 241Gb shows a compressed size of 6.9Gb when it would normally be around 19Gb.
  
  These jobs are run as SQL Agent jobs specifying verify. Is there a setting I should be adding to make sure the backup is deleted if it fails in the creation?
  
  Thanks
  
  Chris

  ChrisAVWood March 25, 2009 17:25

  - 0 +
• 
  SQL Backup doesn't check for available disk space prior to running a backup, as it doesn't know:
  
  1. the volume of the data that needs to be backed up
  2. the compressibility of the above data
  
  At the moment, there isn't an option to delete backup files that have been partially generated.

  petey March 29, 2009 22:31

  - 0 +
• 
  Okay Petey,
  
  Something we will have to watch for in the future. Maybe I should suggest that the backup file be deleted if there is an error in the creation.
  
  Chris

  ChrisAVWood March 30, 2009 11:00

  - 0 +
• 
  I am going to make this a feature request then.
  
  if the backup fails because of an out of space issue then please DELETE the incomplete backup file from the disk.
  
  You should be able to know that this was a disk full problem by the error messages that get thrown.
  
  Chris

  ChrisAVWood April 01, 2009 11:55

  - 0 +
• 
  Hi Chris,
  
  I have logged your feature request.
  
  Thanks,
  Priya

  priyasinha April 02, 2009 06:38

  - 0 +

Add comment

Please sign in to leave a comment.