Licensing
Database Backups
- 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
Backup Storages
-
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
Database-related settings
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
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.
Hi,
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://blog2.sqlbackupandftp.com/full-service-subscription
You can renew your subscriptions by clicking “Renew subscription” at the “Actions” column.
Hello:
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.
Hi Clayton,
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).
hi alex,
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
Hi nawaz,
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://blog2.sqlbackupandftp.com/remote-sql-server-backups-explained
Thank you!
Hello, How do you perform file/folder backups using this tool? I only see options for databases. Thank you.
Hi Robert,
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
Hi Andreas,
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://blog2.sqlbackupandftp.com/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
Hi 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.
Hi Alex,
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?
John.
Licence key *b529 – standard
Hi John,
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.
Hello,
we bought BACKUPANDFTP.
I need your Fiscal Identification Number in U.S.A.
Thank you
Trentin Ghiaia S.r.l.
Hi Guglielmo,
Could you please contact our support team with that request https://sqlbackupandftp.com/support
Thank you!
hello
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
Summary (Failed)
Job: Backup Job – 1
Server: DESKTOP-CU9QK3E
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
Detailed Log:
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?
Thank you.
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.
Hi Nick,
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
Hi Lee,
SQLBackupAndFTP runs on .NET Framework and it does not interact with Java in any way.
Im license user.
PSQL backup create .sql file. it is very difficult and time consume process for restore.
can we create .bak file?? for PSQL DB.
please guide.
Hello Yogesh Sawant,
SQLBackupAndFTP performs logical backups, while backups with the “.bak” extension are physical backups for PostgreSQL.
We apologize, but currently, we do not have plans to add this option.
Thank you.
What is the procedure to restore a diff on top of a full backup?
Backups in SQLBackupAndFTP can be restored using either the backup job or the restore job.
Restore from a Backup Job:
1) Navigate to the “History & Restore” section on the right side of the application.
2) Identify the backup that you wish to restore and click on the three dots next to it.
3) Select “Restore from Backup…”.
Note: If you are restoring a differential, incremental, or transaction log backup, SQLBackupAndFTP will automatically restore all necessary backups in the correct sequence.
Restore via Restore Job:
1) Create a restore job by clicking the “plus” button on the left side of the app or go to Job > Add Restore Job.
Select the location where the backups are stored.
2) Choose the specific backup that should be restored.
3) Connect to your DBMS (e.g., SQL Server local) where you want to restore the backup.
4) Once connected, click the “Save & Close” button to finalize the job settings.
5) After configuring the settings, click the “Restore” button to initiate the backup restoration process.
Hello Jean,
Thank you for your message.
You can easily perform this task using the SQLBackupAndFTP application. Simply select the differential backup you wish to restore from the “History & Restore” column and click on “Restore from Backup”. The application will automatically select the required full backup associated with the differential backup.
If you have any questions or need further assistance, please feel free to contact us