What are the challenges you face when working across database platforms? Take the survey
Options

Automatically delete backup file of failed backup

pjonkpjonk Posts: 6
edited May 27, 2010 7:04AM in SQL Backup Previous Versions
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?

Comments

Sign In or Register to comment.