All posts by Ruslan Sudentas

How we fell for an affiliate scam

We were scammed out of few thousand dollars last month by a fake “affiliate”. Here’s how.

Summary

Like many other sites, we have an affiliate program that  offers 20% commission on any purchases done by customer’s referred by the affiliate. One fake “affiliate” have used stolen credit cards to buy our SQL Server backup software and we have sent real money to him as a commission. Continue reading How we fell for an affiliate scam

Customize backup file name

By default SQLBackupAndFTP stores backups in file names like DatabaseNameYYYYMMDDHHMM.zip (eg Pubs201801011120.zip). But you can also use custom file names if you have such needs

Why use custom formats?

If you want to use it to overwrite the old files – you shouldn’t. There’s auto-delete section  in destination settings that allows you to set auto-delete for old files after a specified number of month/days.

If you store files in Dropbox or other cloud storage that supports versioning, you may choose no date format so that the new file overwrites the old, but Dropbox takes care of storing all the versions of the file.

If you use a script to restore a database on another server, than you may want to use no date file naming. Note however that very soon we will be releasing “Restore job” functionality that allows to set up replication without custom file names.

How to set a custom format?

In SQLBackupAndFTP go to Compression Settings (In Compression section click Settings gear icon) and select one of the formats from the list:

Note that Full backups have no suffix, Differential end with *diff.zip and Transaction Log backup files end with *log.zip

Limitations

By using custom backup file names you are breaking a few things, so before you do that, make sure you are very clear of the trade offs.

  1. Auto-delete won’t work with “no date” format because it needs a date in the file name to understand when it is a time to delete it. It will still work if you have YYYYMMDD format
  2. Tran log backups should not be used with any custom format because they’d overwrite each other.
  3. overwrite the full backup file made on the same day and would make the restore impossible. Only basic full backups should be used.
  4. The automated restore (the one done through our interface) would work only in basic full backup restore scenarios.

Basically, you have to know what you are doing if you are using custom formats.

SqlBackupAndFTP v11 is live

After several years of development the completely reworked v11 is now live. If you have used the previous version – start by reading:
SqlBackupAndFtp v11 – What’s New?

As before, you have several editions including free, but there are a few differences. See:
How SqlBackupAndFtp 11 differs from the previous versions?

For upgrade options from the previous version  see:
How to migrate to SqlBackupAndFtp 11 from the previous versions

Also see:

Why do I Need the “Updates, Web Log & Support” subscription?
Web Log – see backup history on the web
How Tos – SqlBackupAndFtp

If you need help – go to Support Forum