Backup Files created even when SQLBackup errors

ChrisAVWood · March 23, 2009 9:46AM

Hi,

We managed to fill up our backup disk this Saturday because we ran out of disk space during a backup. The partial backup files remained on the disk causing the Sunday backups to fail as well with a lot more partial backup files remaining on the disk.

We run with the cleanup happening after the backup has completed.

Is there a way to have the partial backup files get deleted if SQLBackup fails?

Thanks

Chris

Eddie D · March 25, 2009 3:39PM

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

ChrisAVWood · March 25, 2009 5:25PM

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

petey · March 29, 2009 10:31PM

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.

ChrisAVWood · March 30, 2009 11:00AM

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 · April 1, 2009 11:55AM

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

priyasinha · April 2, 2009 6:38AM

Hi Chris,

I have logged your feature request.

Thanks,
Priya

Backup Files created even when SQLBackup errors

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk