Sql Backup And FTP

I have set the "How long to keep in Local/Network Folder:" option to 0 months and 1 day. And I confirmed that it was set properly in the .jobx file:

<Local Enable="true" Folder="C:\blah blah blah" KeepMonths="0" KeepDays="1" />

However the older backup files are not being deleted. The scheduled job is running as a member of the local Administrators group, so I don't think it's a permission issue. And I have not seen any messages in the Event Log that would indicate that there is a problem.

Has anyone else experienced anything like this?

Jeremy

I just noticed that the file cleanup works when I do full backups, but it does not work when I do differential or log backups.

I have 3 separate jobs set up, all pretty much identical except for the folder in which they pace the backup files and the times they run:

<?xml version="1.0"?>
<JobInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" AllNonSystemDb="false" TempFolder="" LogFolder="C:\_SQLBackupAndFTP\Log" DbTimeout="600">
<SqlServer Server="." User="" Password="" IntegratedSecurity="true" />
<Databases>
<Database>XXX_YYYYYYYY_ZZZZZ</Database>
</Databases>
<Local Enable="true" Folder="C:\_SQLBackupAndFTP\Backups-Full" KeepMonths="0" KeepDays="1" />
<Ftp Enable="true" Uri="ftp://wtrs29002:21/WTRS29003_Database_Backups/Backups-Full" User="XXXXX" Password="YYYYY" KeepMonths="0" KeepDays="1" DataConnection="Passive" Protocol="FTP" TraceLog="false" />
<Email ZeroConfig="false" Enable="true">
<SuccessMail To="" From="DONOTREPLY@systechnologies.com" User="" Password="" SmtpServer="localhost" Port="25" SSL="false" />
<FailureMail To="example@email.com" From="example@email.com" User="" Password="" SmtpServer="localhost" Port="25" SSL="false" />
</Email>
<Run Enable="true" Time="02:00" SchedulerAccount="WTRS29003\XXXXX" />
<Zip Password="" CompressLevel="Highest" EncryptMethod="Compatible" EncryptStrength="256" ZipToTemp="false" />
<SqlScripting ScriptAlways="false" MaxScriptSize="10000" />
</JobInfo>

<?xml version="1.0"?>
<JobInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" AllNonSystemDb="false" TempFolder="" LogFolder="C:\Documents and Settings\XXXXX\_SQLBackupAndFTP\Log" DbTimeout="600">
<SqlServer Server="." User="" Password="" IntegratedSecurity="true" />
<Databases>
<Database>XXX_YYYYYYYY_ZZZZZ</Database>
</Databases>
<Local Enable="true" Folder="C:\Documents and Settings\XXXXX\_SQLBackupAndFTP\Backups-Differential" KeepMonths="0" KeepDays="1" />
<Ftp Enable="true" Uri="ftp://wtrs29002:21/WTRS29003_Database_Backups/Backups-Differential" User="XXXXX" Password="YYYYY" KeepMonths="0" KeepDays="1" DataConnection="Passive" Protocol="FTP" TraceLog="false" />
<Email ZeroConfig="false" Enable="true">
<SuccessMail To="" From="example@email.com" User="" Password="" SmtpServer="localhost" Port="25" SSL="false" />
<FailureMail To="example@email.com" From="example@email.com" User="" Password="" SmtpServer="localhost" Port="25" SSL="false" />
</Email>
<Run Enable="true" Time="02:00" SchedulerAccount="WTRS29003\XXXXX" />
<Zip Password="" CompressLevel="Highest" EncryptMethod="Compatible" EncryptStrength="256" ZipToTemp="false" />
<SqlScripting ScriptAlways="false" MaxScriptSize="10000" />
</JobInfo>

<?xml version="1.0"?>
<JobInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" AllNonSystemDb="false" TempFolder="" LogFolder="C:\_SQLBackupAndFTP\Log" DbTimeout="600">
<SqlServer Server="." User="" Password="" IntegratedSecurity="true" />
<Databases>
<Database>XXX_YYYYYYYY_ZZZZZ</Database>
</Databases>
<Local Enable="true" Folder="C:\_SQLBackupAndFTP\Backups-Log" KeepMonths="0" KeepDays="1" />
<Ftp Enable="true" Uri="ftp://wtrs29002:21/WTRS29003_Database_Backups/Backups-Log" User="XXXXXXXXXXXXXX" Password="XXXXXXXXXXXXXXX" KeepMonths="0" KeepDays="1" DataConnection="Passive" Protocol="FTP" TraceLog="false" />
<Email ZeroConfig="false" Enable="true">
<SuccessMail To="" From="example@email.com" User="" Password="" SmtpServer="localhost" Port="25" SSL="false" />
<FailureMail To="example@email.com" From="example@email.com" User="" Password="" SmtpServer="localhost" Port="25" SSL="false" />
</Email>
<Run Enable="true" Time="03:30" SchedulerAccount="WTRS29003\XXXXX" />
<Zip Password="" CompressLevel="Highest" EncryptMethod="Compatible" EncryptStrength="256" ZipToTemp="false" />
<SqlScripting ScriptAlways="false" MaxScriptSize="10000" />
</JobInfo>


Here are the Windows Scheduler tasks that run the jobs:

"C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\_SQLBackupAndFTP\Jobs\Weekly (Sunday) Full Backups 0200.jobx"

"C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\_SQLBackupAndFTP\Jobs\Daily Differential Backups 0200.jobx" -diff

"C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\_SQLBackupAndFTP\Jobs\Hourly Log Backups.jobx" -log


And here's some text from the log file for the last full backup and last log backup:

>>> run 4/6/2010 12:30:07 PM by XXXXX

SqlBackupAndFtp 4.4.0.22819 (Professional)

SUMMARY:
>>> run 4/6/2010 12:25:33 PM by XXXXX

SqlBackupAndFtp 4.4.0.22819 (Professional)

SUMMARY:
Database XXX_YYYYYYYY_ZZZZZ: Backup - Success, FTP - Success

DETAILED LOG:
4/6/2010 12:17:05 PM Creating backup of XXX_YYYYYYYY_ZZZZZ to C:\WINNT\TEMP
4/6/2010 12:18:00 PM Backup of XXX_YYYYYYYY_ZZZZZ completed
4/6/2010 12:18:00 PM Zipping C:\WINNT\TEMP\XXX_YYYYYYYY_ZZZZZ201004061217.bak to C:\_SQLBackupAndFTP\Backups-Full\XXX_YYYYYYYY_ZZZZZ201004061217.zip
4/6/2010 12:25:06 PM Zip completed (compressed size: 275,234 Kb)
4/6/2010 12:25:06 PM Removing the backup: C:\WINNT\TEMP\XXX_YYYYYYYY_ZZZZZ201004061217.bak
4/6/2010 12:25:06 PM Uploading C:\_SQLBackupAndFTP\Backups-Full\XXX_YYYYYYYY_ZZZZZ201004061217.zip to ftp://wtrs29002:21/WTRS29003_Database_Backups/Backups-Full
4/6/2010 12:25:32 PM Upload of C:\_SQLBackupAndFTP\Backups-Full\XXX_YYYYYYYY_ZZZZZ201004061217.zip completed
4/6/2010 12:25:32 PM Remote file size has been successfully verified
4/6/2010 12:25:32 PM Cleaning C:\_SQLBackupAndFTP\Backups-Full
4/6/2010 12:25:32 PM Removing XXX_YYYYYYYY_ZZZZZ201004040230.zip
4/6/2010 12:25:32 PM Cleaning ftp://wtrs29002:21/WTRS29003_Database_Backups/Backups-Full
4/6/2010 12:25:32 PM Removing XXX_YYYYYYYY_ZZZZZ201004040230.zip
4/6/2010 12:25:33 PM Sending a confirmation e-mail (Success) to (SMTP)
4/6/2010 12:25:33 PM Job finished

>>> run 4/6/2010 12:05:31 PM by XXXXX

SqlBackupAndFtp 4.4.0.22819 (Professional)

SUMMARY:
Database XXX_YYYYYYYY_ZZZZZ: Backup - Success, FTP - Success

DETAILED LOG:
4/6/2010 12:05:28 PM Creating backup of XXX_YYYYYYYY_ZZZZZ to C:\WINNT\TEMP (transaction log)
4/6/2010 12:05:29 PM Backup of XXX_YYYYYYYY_ZZZZZ completed
4/6/2010 12:05:29 PM Zipping C:\WINNT\TEMP\XXX_YYYYYYYY_ZZZZZ201004061205log.bak to C:\_SQLBackupAndFTP\Backups-Log\XXX_YYYYYYYY_ZZZZZ201004061205log.zip
4/6/2010 12:05:29 PM Zip completed (compressed size: 15 Kb)
4/6/2010 12:05:29 PM Removing the backup: C:\WINNT\TEMP\XXX_YYYYYYYY_ZZZZZ201004061205log.bak
4/6/2010 12:05:29 PM Uploading C:\_SQLBackupAndFTP\Backups-Log\XXX_YYYYYYYY_ZZZZZ201004061205log.zip to ftp://wtrs29002:21/WTRS29003_Database_Backups/Backups-Log
4/6/2010 12:05:29 PM Upload of C:\_SQLBackupAndFTP\Backups-Log\XXX_YYYYYYYY_ZZZZZ201004061205log.zip completed
4/6/2010 12:05:30 PM Remote file size has been successfully verified
4/6/2010 12:05:30 PM Cleaning C:\_SQLBackupAndFTP\Backups-Log
4/6/2010 12:05:30 PM Cleaning ftp://wtrs29002:21/WTRS29003_Database_Backups/Backups-Log
4/6/2010 12:05:31 PM Sending a confirmation e-mail (Success) to (SMTP)
4/6/2010 12:05:31 PM Job finished

Seems to be working now. Thanks for the speedy fix.