Backup files not being deleted

philcart · June 12, 2007 2:24AM

Running SQL Backup 5.1.0.2781 on SQL Server 2005 (SP2)

This is the command thats being issued,

BACKUP DATABASE &#91;myDB&#93;  TO DISK = 'H:\backup_share\&lt;AUTO&gt;.sqb' 
WITH NAME = '&lt;AUTO&gt;', DESCRIPTION = '&lt;AUTO&gt;', 
COPYTO = '\\SQL2\db', FILEOPTIONS = 7, 
ERASEFILES = 2, COMPRESSION = 2, THREADCOUNT = 7

By my reading SQL Backup should be erasing all files that are more than two days old in both the primary and COPYTO locations, which it is not doing. No files are being deleted at all.

If the command is not correct, please advise what I need to change so the command works.

Thanks
Phil

petey · June 12, 2007 3:08AM

The using FILEOPTIONS = 7, which includes bitmask 1 (the value 2), SQL Backup will only delete files that do not have the archive attribute.

The archive attribute is usually set by default. It is usually cleared by tape backup applications, to indicate that the file has been archived to tape, and need not be archived again.

If you want to delete the file regardless of the archive attribute, then use FILEOPTIONS = 5.

philcart · June 12, 2007 5:40AM

So will FILEOPTIONS=5 delete files in both the primary and COPYTO locations?

Thanks

Backup files not being deleted

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk