Modify the Output Filename in SQL Backup & Restore Wizard

You can do this by modifying the Task Xml document to include the tag $FILETIME$ in the path for the output file name. To do this locate the Task Xml File either by looking in the directory C:\ProgramData\Simego\Backup.Wizard.Tasks or Lookup the path from the Windows Task scheduler properties.

 

The filename will be some like ServerName-InstanceName-DatabaseName.xml then make changes as highlighted below this will then include the time in the filename.

<Task Name="Prepare">
  <NVCollection>
    <NV Name="Server" DataType="String" Value=".\SQLEXPRESS" />
    <NV Name="LoginMode" DataType="String" Value="Trusted" />
    <NV Name="Database" DataType="String" Value="Database" />
    <NV Name="Destination" DataType="String" Value="C:\Users\Sean\Documents\$DATABASE$" />
    <NV Name="BackupFileName" DataType="String" Value="$DATABASE$-$FILEDATE$-$FILETIME$.bck" />
    <NV Name="ZipFileName" DataType="String" Value="$DATABASE$-$FILEDATE$-$FILETIME$.zip" />
  </NVCollection>
  <OnSuccess>
    <Task Name="BackupDatabase">
      <OnSuccess>
        <Task Name="CompressFiles">
          <OnSuccess>
            <Task Name="CopyFiles">
              <NVCollection>
                <NV Name="FileMask" DataType="String" Value="*.zip" />
              </NVCollection>
              <OnSuccess>
                <Task Name="EventLog">
                  <NVCollection>
                    <NV Name="EventSource" DataType="String" Value="Simego SQL Backup Wizard" />
                    <NV Name="EventMessage" DataType="String" Value="Backup of Database $DATABASE$ Completed Successfully." />
                  </NVCollection>
                </Task>
              </OnSuccess>
            </Task>
          </OnSuccess>
        </Task>
      </OnSuccess>
    </Task>
  </OnSuccess>
</Task>