Automatically delete backup file of failed backup
pjonk
Posts: 6
There are numerous errors that can occur during a backup. One of them is too few diskspace which gives errors such as.
WriteFile failed for file: g:\backup\AdventureWorks_FULL_20100526_1714.sqb at position: 41944064 26-05-2010 17:14:56: WriteFile failed for file: g:\backup\AdventureWorks_FULL_20100526_1714.sqb (There is not enough space on the disk.)
This error results in an incomplete backup file which is of course worth nothing. I notice SQL Backup does not delete this file automatically? Is there a way to enable such functionality or do I need do implement this myself using the ERASE command for example?
WriteFile failed for file: g:\backup\AdventureWorks_FULL_20100526_1714.sqb at position: 41944064 26-05-2010 17:14:56: WriteFile failed for file: g:\backup\AdventureWorks_FULL_20100526_1714.sqb (There is not enough space on the disk.)
This error results in an incomplete backup file which is of course worth nothing. I notice SQL Backup does not delete this file automatically? Is there a way to enable such functionality or do I need do implement this myself using the ERASE command for example?
Comments
Chris