We've recently installed SQL Backup and FTP version 5.7.1.23664 on Windows 2008 Server R2. It seems to be working well. However, we've noticed that after saving and re-opening a job definition (.jobx file) that our specified "Auto delete after" setting is reverting to 1 months, 0 days in the UI display. The definition remains
correct in the actual XML file. But if we then re-save the file from the UI after re-opening, it writes the incorrect (1 month) auto delete setting into the file.
For example, we've pasted below one of our backup jobs(having removed some e-mail address and mail server detail). Note that Local KeepMonths="12". If, however, we open this file in the UI, it displays an auto delete setting of
1 months, 0 days. As I said above, we've also noticed that the 1 month setting will get saved back into this file if we then click "Save" in the UI.
By the way, we haven't run the program long enough to know if this is a UI only issue, or if the logic in the program will actually retain only 1 month of backups, even if the XML file says 12 months. Thanks very much for a terrific program! --Glenn
Code:<?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="" DbTimeout="10000" UseWebLog="false">
<SqlServer Server="." User="" Password="" IntegratedSecurity="true" />
<Databases>
<Database>MyDatabase</Database>
</Databases>
<Folders />
<Local Enable="true" Folder="C:\Backups\Monthly" KeepMonths="12" KeepDays="0" />
<Ftp Enable="false" Uri="" User="" Password="" KeepMonths="1" KeepDays="0" DataConnection="Passive" Protocol="FTP" TraceLog="false" />
<Email ZeroConfig="false" Enable="true">
<SuccessMail To="" From="" User="" Password="" SmtpServer="" Port="25" SSL="false" />
<FailureMail To="" From="" User="" Password="" SmtpServer="" Port="25" SSL="false" />
</Email>
<Run Enable="true" Time="01:00" SchedulerAccount="" FullBackupEnabled="false" FullBackupIntervalH="24" DiffBackupEnabled="false" DiffBackupIntervalH="0" TransactionLogEnabled="false" TransactionLogIntervalH="0" TransactionLogIntervalM="0" AutoDeleteOld="false" />
<Zip Password="" CompressLevel="Highest" EncryptMethod="Compatible" EncryptStrength="256" ZipToTemp="false" />
<SqlScripting ScriptAlways="false" MaxScriptSize="10000" />
<ScriptBefore />
<ScriptAfter />
<OutputFormat>DateTime</OutputFormat>
</JobInfo>