Sql Backup And FTP

It would be useful to be able to change the file name of the backup because at the moment, as it's linked to the date, it always unique but this means the FTP site just gets fuller and fuller.

If you had the option of linking the file name directly to the day (Monday, Tuesday etc) then the files on the FTP would get overwritten each week and you would only get a maximum of 7 files.

I also support this being added as a feature. I have my backups created in a local folder, and that folder is then backed up using one of the many online backup services. (I use Data Deposit Box) The "keep 7 days" option in SQLBackupandFTP limits me to 7 copies in my local folder, but because the online backup service does not automatically delete files no longer on the local system (a key feature for most file types), this means that my data storage online grows continually. Given the common use of online backup services today, to have this option in SQLBackupandFTP would be great so that we don't continually have newly-named files and manage the online backup versions to 7 only.

ruslan, thanks for your reply and the link, and I look forward to seeing the new naming option in a later version. It will be a big improvement.

For Kevin, I had to solve the issue NOW, and did so using a VB6 EXE that I have Task Scheduler run 5 minutes after the scheduled backup. In case you want to do the same thing, here is the code. All you need is a folder that SQLBackupandFTP saves the source backups into (with default naming) and a separate folder for the renamed backups to go to. Put in the correct source and destination folder paths below, compile this as a VB6 EXE, and you are good to go.

*********************************

Sub Main()

On Error GoTo Errorhandler

'Use FileSystemObject to copy files
Dim objFSO As Scripting.FileSystemObject
Set objFSO = CreateObject("Scripting.FileSystemObject")

'Get the source backup folder and its collection of files
Dim objFolder As Scripting.Folder
Set objFolder = objFSO.GetFolder("C:\SQL Server Backups\Source Backups")
Dim objFiles As Scripting.Files
Set objFiles = objFolder.Files
Dim strFileName As String
Dim strNewFileName As String
Dim strDayOfWeek As String

'Determine current day of week
strDayOfWeek = WeekdayName(Weekday(Now), True)

'Copy the current live files to the renamed folder and delete them
Dim file As Scripting.file
For Each file In objFiles
If file.Type = "Compressed (zipped) Folder" Then
strFileName = file.Name
strNewFileName = Left(strFileName, InStr(1, strFileName, ".") - 9) & "_" & strDayOfWeek & ".zip"
file.Name = strNewFileName
file.Copy "C:\SQL Server Backups\Renamed Backups\", True
file.Delete
End If
Next

'Release objects
Set file = Nothing
Set objFiles = Nothing
Set objFolder = Nothing

Exit Sub

Errorhandler:

Exit Sub

End Sub

You don't need to wait for a new version to use DropBox. My favorite configuration is to select "Backup to local folder" in SQLBackupAndFTP and set the target folder to "My Dropbox". "My Dropbox" then automatically syncs with Dropbox servers.
And yes, withing a month we will release a version that would support different file formats:
1. [DbName]YYYYMMDDHHMM.zip (default)
2. [DbName]YYYYMMDD.zip
3. [DbName]DayOfMonth.zip
4. [DbName]DayOfWeek.zip
5. [DbName].zip

See this post for details

Understood. Dropbox doesn't do "diff" backup last time I checked. Once new version is ready, I'll post about it here.

Wow, it's a pleasant surprise. No need for differential backups any more since Dropbox will handle it. Almost too good to be true. Needs testing.

Great work ruslan, keep up the great work on a fantastic piece of software!