Frequently Asked Questions (SQLBackupAndFTP)

This FAQ section is a short version of forum. There you can discuss FTP, Remote/Script backup , Advanced and other issues.

Features FAQ

See features for full list of features and comparison between Free, Standard and Professional versions. For details see How does SQLBackupAndFTP work? in forum.

Q: Is there a tutorial on how to configure SQLBackupAndFTP?

A: See the SQLBackupAndFTP tutorial

Q: What can I do with SQLBackupAndFTP?

A: You can run scheduled backups of SQL Server databases (full, differential or transaction log), run file/folder backup, zip and encrypt the backups, store them on a network, FTP server, Dropbox, Amazon S3 or Google Drive, send yourself an e-mail confirmation on job success of failure.

Q: How do I restore backups?

A: Any way you want - it is a standard SQL server backup in a common zip file. For a simplest way to restore full backups use One-Click SQL Restore included free with SQLBackupAndFTP. See this post for details.

Q: Do you provide the storage?

A: No. It is up to you where to store the backups, we just provide the tool. If don't know where to start - get a free account on Dropbox.

Q: Can SQLBackupAndFTP do Remote Backups?

A: Yes, but use at your own risk - the feature is in permanent beta and we do not provide tech support for it, see details or discuss remote backup .

Q: What is the difference between Free and other versions?

A: See compare features

Q: Does it run as a service? Does it need to be started?

A: The start is triggered by Windows Scheduler when the job is scheduled to run once a day or a service in more complicated scenarios. The program will run just fine after system restart and you do not need to be logged-in for it to start.

Q: How to set differential or transaction log backups?

A: Click on "Advanced Schedule" button - you will find all the options there.

Q: Does SQLBackupAndFTP have a command line interface?

A: Yes. See this post . Note that command-line options are additional to the options you have in .jobx file. Consider them to be "modifiers" of options saved in .jobx file. Also .jobx is just an XML file - you can edit it in Notepad.

Q: Can I change the default [DatabaseOrFolderName] output file format?

A: Yes. In advanced settings.

Q: Can it run on more than one SQL instance? I want to backup both SQL 2005 and SQL 2008 on my server.

A: Yes, just create a separate job for each SQL instance.

Q: Is it possible to run the backup while the database in being used?

A: Yes, the backup usually has just a minor effect on a performance.


Q: What kind of Zip file encryption is supported?

A: SQLBackupAndFTP provides 2 encryption methods (available in Professional version only)
1. ZIP compatible
It supports a simple password-based symmetric encryption. Note that it provides basic encryption only and is vulnerable to known-plaintext attacks. You can use built-in Windows compressor to open backups encrypted using ZIP compatible encryption method.

2. WinZip AES
AES is a strong encryption standard adopted by the U.S. government. Built-in Windows compressor does not support AES files, so you have to use 7Zip (freeware) or WinZip 9.0 (or higher) to open backups encrypted using WinZip AES encryption method.

Also, note that backup files over 2 GB are zipped using Zip64 format.
The built-in Windows compressor does not support Zip64, so use 7Zip (freeware) or other archiver to uncompress it. You can find more details in this topic


Q: Can I get a trial version to test Amazon S3, Google Drive or other options not available in free version?

A: Just download the free version, then in the menu select Help > Start 30 days Free Trial. All the functionality of Professional version will be available to you for 30 days.

Q: How long is my license valid?

A: The license has no expiration limit for paid versions that you buy. However, the Automatic e-mail service that you buy with the license is valid for one year only.

Q: May I install the software on more than one computer?

A: No. You need a separate license for each installation. You can install it on another computer only after uninstalling it from the first.

Q: When I enter the key I receive "This license key you have entered is not valid for version ..."?

A: The license you buy is valid for the current version only. It is guaranteed to work with any new version for 30 days after the purchase. After that if you want to use the latest SQLBackupAndFTP version, you can purchase an upgrade. To download the version that you own (and your keys), go to Resend page

Q: On Upgrade page you say: "Once you have purchased a new key, your old key becomes invalid". What do you mean?

A: "Automatic email" service won't work and you are under the obligation to destroy the old key and not to use it.

Q: Can I distribute SQLBackupAndFTP with my own software product?

A: It depends. You can distribute unmodified paid version as long as 1 license is active on 1 computer. Contact us for OEM discounts, customization and private label options.  You can distribute the free version with your software provided that you put a permanent direct link to on a public page of your website with a brief description of how it is being used. Please let us know about this link prior to distributing our product.

Sending E-mails

Q: What is "Automated" e-mail settings option?

A: In paid versions on E-Mail settings form you can select "Automatic" option. If it is selected, all of the confirmation e-mails will be sent through a Web service on A user would not need to set any e-mail settings other than recipient's e-mail.

Q: Can I send e-mail confirmations through my GMail/Hotmail/Yahoo account?

See these posts: GMail, Hotmail , Yahoo

Q: Can I send e-mail confirmations to multiple e-mails?

A: Yes, just separate e-mails by a comma.


Q: I cannot connect to my database. What is wrong?

A: Use SQL Server Management Studio to connect, and once successful - use the same parameters for SQLBackupAndFTP.

Q: A job runs fine with "Run Now" button, but when scheduled, gives errors?

A: When a scheduler tries to run a job, it runs under Local System account that (unlike your personal account) does not have access to the network. Just go to "Advanced settings" and set the job to run under you own personal account.

Q: I cannot connect to my FTP server.

A: Try unchecking "Use Passive FTP mode" in FTP Settings form. Browse topics in FTP forum for more.

Q: I get Timeout error while backing up a large database

A: Increase the database timeout in advanced settings

Q: My temp folder is too small, can I change its location?

A: In advanced settings change the temp folder location (to other drive)

Q: I do not receive e-mail confirmations, what's wrong?

A: By default SQLBackupAndFTP uses "Automated" e-mail configuration. Free users have 7 days to use it, paid users - 1 year. You have probably missed our notifications about service expiration. Just set up your own mail server (or GMail) through "E-Mail settings".

Q: Is there a log available?

A: Right on the main form there's a button "Log" that brings up a text file with all the logs. In addition a Windows Event Log Event is written when a job results in a failure. It can be seen in Administrative Tools > Event Viewer > Application.

Q: "Unable to relay" error when sending e-mails?

A: You Email server settings are incorrect. The specified SMTP server could not authenticate you as a legitimate user. See more.

Q: "ERROR: Script execution failed: Incorrect syntax near 'GO'." error when executing custom SQL script?

A: You should not use GO commands in custom SQL scripts. See more.


Our Backup Products

SQL Backup SQL Backup And FTP - MS SQL Server & Azure database backup
SQL Restore One-Click SQL Restore - MS SQL Server backup restore
MySQL Backup MySQL Backup FTP (MySqlBF) - MySQL database backup
PostgreSQL Backup PostgreSQL Backup - PostgreSQL database backup

Install in a Nutshell

  • Install SQLBackupAndFTP on the Database Server (strongly recommended) or on any PC where you can connect to the Database Server
  • Choose databases to backup, FTP to send, e-mail to confirm and time to run
  • Run once to make sure all is working
  • Forget about it: the job will run it at previously specified time


Compare Features


  • SQL Server 2014 Express
  • SQL Server 2012 Express
  • SQL Server 2008 Express
  • SQL Server 2005 Express
  • SQL Server 2016 - all editions
  • SQL Server 2014 - all editions
  • SQL Server 2012 - all editions
  • SQL Server 2008 - all editions
  • SQL Server 2005 - all editions
  • Win2000, WinXP, Win2003, Windows Vista, Win2008, Windows 7, Windows 8, Win2012

Copyright © 2017 Pranas.NETBack to Top