- How to Backup SQL Database Automatically
- How to Backup SQL Server 2016
- How to backup multiple servers
- How to specify backup’s lifetime
- How to remove old backups
- How to lower the priority of 7-zip process
- How to Backup SQL Server to FTP Server
- How to backup to UNC Path
- How to backup a SQL Server database to NAS drive
- How to Backup SQL Server to Local or Network Folder
- How to Backup SQL Server to Azure Storage
- How to Backup SQL Server to Amazon S3
- How to Backup SQL Server to OneDrive
- How to Backup SQL Server to Dropbox
- How to Backup SQL Server to Google Drive
- How to save SQL Server backups to Azure
Security & Reliability
- How to get SQL Server backup Email Notification
- How to verify backup files after backup
- How to perform SQL Server maintenance
- How to encrypt SQL server backups
27 thoughts on “How Tos – SQLBackupAndFTP”
Hello I paid $89 for a standard license #22875 invoice number #56676. I prefer it should be at least good for a year. But it stop working after a month. All back up is failed. Request me to pay $48 again. Please inform me why? and how to make it good again.
We have checked your account and found out that you have purchased SQLBackupAndFTP Standard edition without the one-year Full-Service subscription. It means that you have only one-month Full-Service subscription which is expired.
Your license never expires and you can use the version you’ve purchased forever. However zero-config email service for sending backup notifications, support, weblog, free upgrades, and service down alerts are parts of the optional Full-Service subscription and requires a yearly recurring fee.
Please find more details at: https://sqlbackupandftp.com/blog/full-service-subscription
You can renew your subscriptions by clicking “Renew subscription” at the “Actions” column.
To whom it may concern:
I just purchased a product and defined our backup job, but the logs are saying that the database maximum size is 10G. Our databases are larger than that. Is there a way this issue can be resolved by increasing the size ? If not, I would like to request a refund.
The maximum file size of 10.000GB is set by your destination place and it cannot be changed with SQLBackupAndFTP. In spite of that restriction, your backups with any size are still being uploaded to the selected destination place, but the will be split into the volumes. You can manage the size of the volumes at the “Compression Settings” at the “Split to volumes” section (but the volumes cannot be larger then destinations are allowed).
i am facing the same issue ,i have db backup of size 14 gb but it transferring at remote location with 9GB.
need your help
It seems you use Microsoft SQL Server (remote) as your server’s type during the connection.
When using this server’s type during the connection, SQLBackupAndFTP generates a T-SQL script to recreate a database. The size of such a file may be less than the size of the database files and it is normal. This is because the database contains not only data pages but also index pages.
If you install the application on the same computer where SQL Server is installed and connect using Microsoft SQL Server (local) server type, then a backup size will be very close to the size of the database.
It is highly recommended to use Microsoft SQL Server Connection (local) as your server’s type during the connection since such a backup is faster, and it is possible to perform differential and transaction log backups, and the process of creating a backup is much less load the server.
Here is more information about the remote and local backups https://sqlbackupandftp.com/blog/remote-sql-server-backups-explained
Hello, How do you perform file/folder backups using this tool? I only see options for databases. Thank you.
Along with your databases, you can backup local files and folders. You can find that option at the “Backup folders” option. Just scroll down at the main window of the application.
Hi, i would like to backup a database into a file with the same filename (overwrite it each time the backup runs) because i want to auto-restore it to another database and i found no way of how to do it with the current backup method … so i have to choose one file to restore. We bought the standard license so i have no idea if a naming module is included in a higher version!
kind regards andy
To delete old backup files you can use the “Auto delete” option which can be founded at the backup destination settings.
With SQLBackupAndFTP you can not run a restore job automatically according to the schedule, but you can run a restore job via Command Prompt and use Windows Scheduler. Here are more details: https://sqlbackupandftp.com/blog/run-sqlbackupandftp-v11-command-line
Also, you can try our another tool SqlBak https://sqlbak.com set a “Restore on another computer” option at your backup job, then the restore process will run automatically just after the backup.
Hi, if I’ll set schedule to make automatic backup for MySQL to Dropbox, than turn off my computer, will sqlbackupadnftp make backups even if my computer will be switch off many weeks? Kind regards Piotr
If you turn off a computer, then the backups will no be performed.
Please let us know if you have any further questions.
Please specify any relevant transmission protocols (eg. HTTPS)that would indicate how safely the information is transmitted?
Which port does this tool use in backend ftp, telner or ssh?
All communications with our Web site and API are carried out via the HTTPS protocol.
I’m trying to restore a back up made 5 days ago to a local folder, the process seems quite simple (select a back up location and click restore) – a green tick is displayed instantly indicating success but then no back up file is made. Any suggestions?
Licence key *b529 – standard
Could you please contact our support team to check the issue https://sqlbackupandftp.com/support
Please provide us as much as possible information about the issue.
Sorry for the inconvenience.
we bought BACKUPANDFTP.
I need your Fiscal Identification Number in U.S.A.
Trentin Ghiaia S.r.l.
Could you please contact our support team with that request https://sqlbackupandftp.com/support
a week ago I started to get an error when connecting and it says cant read databese.unknow error.
I do this in mysql / phpmyadmin
I was checking and I did not find the problem that is why I join you by ask
Backup Job – 1 backup has failed
Job: Backup Job – 1
Date: 11/6/2021 4:34:28 PM
Backup type: Full
Backup archive size: 0B
MorthoTest Database backup: failed
MOrthoTestNew Database backup: failed
master Database backup: failed
Next backup: 11/7/2021 9:26:00 AM – Full
4:34:28 PM : Starting job “Backup Job – 1 ” – “Full”. Server “DESKTOP-CU9QK3E”. System account “SYSTEM@WORKGROUP”. App v.”12.6.7″.
4:34:28 PM : Connecting to: 2014 RTM SQL Azure. tcp:morthotest.database.windows.net,1433.
4:34:29 PM : The temporary folder “F:SQLBackupstempPranas.NETSBF93adcc9a-1a50-4ddf-86c9-1c325fddf1c3backup” has “1.748TB” free space.
4:34:29 PM : Backing up “tcp:morthotest.database.windows.net,1433” SQL Server databases.
4:34:29 PM : Backing up “MorthoTest” with “Full” backup type.
4:34:29 PM : ERROR: Failed to backup “MorthoTest” database with “Full” backup type: One or more errors occurred. > Statement ‘BACKUP DATABASE’ is not supported in this version of SQL Server.
4:34:29 PM : Backing up “MOrthoTestNew” with “Full” backup type.
4:34:29 PM : ERROR: Failed to backup “MOrthoTestNew” database with “Full” backup type: One or more errors occurred. > Statement ‘BACKUP DATABASE’ is not supported in this version of SQL Server.
4:34:29 PM : Backing up “master” with “Full” backup type.
4:34:29 PM : ERROR: Failed to backup “master” database with “Full” backup type: One or more errors occurred. > Statement ‘BACKUP DATABASE’ is not supported in this version of SQL Server.
4:34:29 PM : Cleaning up backups of “Backup Job – 1 ” job.
4:34:29 PM : Deleting temporary files.
4:34:29 PM : ERROR: Job “Backup Job – 1 ” finished with “3” errors.
Hi Michael Murphy.
It seems you use the wrong server type during the connection. Could you please make sure you use Azure SQL Server and try again?
Feature suggestion (unless there is already a way to do it:) I feel it would be useful to configure compression per folder on a single backup job going to multiple folders. I would prefer to have one “local” uncompressed version for quicker restore if needed, and allow the additional folders (local and offsite) to maintain compression. I know I could accomplish this with two backup jobs, but think others may see value in this as well. Thank you.
Thank you for your request, we’ll consider it.
Thank you for using SQLBackupAndFTP!
When do you plan on adding the off-line license install? We have more than two databases and would like to use the professional lifetime version. Connecting to the internet is physically impossible.
Hi Kent Jones,
SQLBackupAndFTP can work without an internet connection, but at least once in 60 days, a connection should be set for license validation.
We have SQLBackupAndFTP running on one of our servers. I’ve noticed we also have java installed and wonder if SQLBackupAndFTP has any link to java at all?
I want to unistall java, but cautious incase its required
SQLBackupAndFTP runs on .NET Framework and it does not interact with Java in any way.