Scheduled backups do not work, manual do

Hi there, i love the free version of SQLBackupandFTP. Very generous of you guys to make it availlable for “small people”. I do backup ONE Database. When i start the backup manually it still works fine, also the scheduled backups for a few months. Without any updates, now scheduled backups do not work anymore. When i check the log it says:

08.09.2023 21:12:01 [Error] Job execution error: Free license allows backup 2 database(s) only. Server name: “VIDEOSTATION”.

SQLBackup V 12.7.18 is running on the same machine where the Database resides.

It is just one database. I do not understand the error. Please ellaborate.

Thank you very much and best regards
Holle

Hello Holle,

After making changes to your backup job and identifying an issue related to the limitation of the version you are using, you will need to wait for 24 hours. During this period, the number of database backups will be reset. Please wait for this period to complete and then verify if the process is running smoothly.

If you have any additional questions, please do not hesitate to ask.

We appreciate your understanding and apologize for any inconvenience this may cause.

Hi Alexander, since manual backups do work, you are saying i should deactivate the 2-hour-scheduled backup for at least 24 hours and reactivate after? I haven´t changed anything in SQLbackupandFTP and it was working for a few months …

this is the last error log:

16.09.2023 09:12 Starting scheduled job "Backup Job - 1 " - “Full”. Server “VIDEOSTATION-1”. System account “SYSTEM@WORKGROUP”. App v.“12.7.18”.
16.09.2023 09:12 Connecting to “PostgreSQL Server”: “127.0.0.1”.
16.09.2023 09:12 Connected to “PostgreSQL 13.4, compiled by Visual C++ build 1914, 64-bit”.
16.09.2023 09:12 The backup folder “C:\Windows\TEMP\SYSTEM\Pranas.NET\SBF\174df7ba-71ff-49c1-939c-51699035e6be\backup” has “535,186GB” free space. The temporary folder “C:\Windows\TEMP\SYSTEM\Pranas.NET\SBF\174df7ba-71ff-49c1-939c-51699035e6be” has “535,186GB” free space.
16.09.2023 09:12 Backing up “127.0.0.1” databases with “pg_dump.exe: pg_dump (PostgreSQL) 15.1”
16.09.2023 09:12 Job execution error: Free license allows backup 2 database(s) only. Server name: “VIDEOSTATION-1”.
16.09.2023 09:12 Deleting temporary files.
16.09.2023 09:12 Job "Backup Job - 1 " finished with “1” errors.

Edit: this is a log of a manual backup of the same job (names edited, not allowed to post more than 2 “links”?):

16.09.2023 09:58 Starting job "Backup Job - 1 " - “Full”. Server “VIDEOSTATION-1”. System account “SYSTEM@WORKGROUP”. App v.“12.7.18”.
16.09.2023 09:58 Connecting to “PostgreSQL Server”: “127.0.0.1”.
16.09.2023 09:58 Connected to “PostgreSQL 13.4, compiled by Visual C++ build 1914, 64-bit”.
16.09.2023 09:58 The backup folder “C:\Windows\TEMP\SYSTEM\Pranas\SBF\174df7ba-71ff-49c1-939c-51699035e6be\backup” has “535,214GB” free space. The temporary folder “C:\Windows\TEMP\SYSTEM\Pranas\SBF\174df7ba-71ff-49c1-939c-51699035e6be” has “535,214GB” free space.
16.09.2023 09:58 Backing up “127.0.0.1” databases with “pg_dump.exe: pg_dump (PostgreSQL) 15.1”
16.09.2023 09:58 Backing up “resolve_project_server_config” with “Full” backup type.
16.09.2023 09:58 Database “resolve_project_server_config” successfully backed up to “C:\Windows\TEMP\SYSTEM\Pranas\SBF\174df7ba-71ff-49c1-939c-51699035e6be\backup\resolve_project_server_config202309161158.sql : 1,542KB”.
16.09.2023 09:58 Compressing “C:\Windows\TEMP\SYSTEM\Pranas\SBF\174df7ba-71ff-49c1-939c-51699035e6be\backup\resolve_project_server_config202309161158.sql” file with Internal archiver. Encryption: “Off”.
16.09.2023 09:58 Backup of “resolve_project_server_config” successfully compressed to “(resolve_project_server_config202309161158.zip : 1,144KB)”.
16.09.2023 09:58 Backing up “Machine_DaVinci_Server” with “Full” backup type.
16.09.2023 09:59 Database “Machine_DaVinci_Server” successfully backed up to “C:\Windows\TEMP\SYSTEM\Pranas.NET\SBF\174df7ba-71ff-49c1-939c-51699035e6be\backup\Machine_DaVinci_Server202309161158.sql : 664,577MB”.
16.09.2023 09:59 Compressing “C:\Windows\TEMP\SYSTEM\Pranas\SBF\174df7ba-71ff-49c1-939c-51699035e6be\backup\Machine_DaVinci_Server202309161158.sql” file with Internal archiver. Encryption: “Off”.
16.09.2023 09:59 Backup of “Machine_DaVinci_Server” successfully compressed to “(Machine_DaVinci_Server202309161158.zip : 208,8MB)”.
16.09.2023 09:59 Backing up “Project_Server” with “Full” backup type.
16.09.2023 09:59 Database “Project_Server” successfully backed up to “C:\Windows\TEMP\SYSTEM\Pranas\SBF\174df7ba-71ff-49c1-939c-51699035e6be\backup\Project_Server202309161159.sql : 888MB”.
16.09.2023 09:59 Compressing “C:\Windows\TEMP\SYSTEM\Pranas\SBF\174df7ba-71ff-49c1-939c-51699035e6be\backup\Project_Server202309161159.sql” file with Internal archiver. Encryption: “Off”.
16.09.2023 09:59 Backup of “Project_Server” successfully compressed to “(Project_Server202309161159.zip : 251,912MB)”.
16.09.2023 09:59 Backing up “postgres” with “Full” backup type.
16.09.2023 09:59 Database “postgres” successfully backed up to “C:\Windows\TEMP\SYSTEM\Pranas.NET\SBF\174df7ba-71ff-49c1-939c-51699035e6be\backup\postgres202309161159.sql : 1.013B”.
16.09.2023 09:59 Compressing “C:\Windows\TEMP\SYSTEM\Pranas\SBF\174df7ba-71ff-49c1-939c-51699035e6be\backup\postgres202309161159.sql” file with Internal archiver. Encryption: “Off”.
16.09.2023 09:59 Backup of “postgres” successfully compressed to “(postgres202309161159.zip : 860B)”.
16.09.2023 09:59 Connecting to “Folder” destination “\Qnap\archiv\1.BACKUP_DaVinciServer”.
16.09.2023 09:59 Reading folder information by path: “\Qnap\archiv\1.BACKUP_DaVinciServer”.
16.09.2023 09:59 The current destination folder is “\Qnap\archiv\1.BACKUP_DaVinciServer”.
16.09.2023 09:59 Sending backup of “resolve_project_server_config” to “Folder” destination “\Qnap\archiv\1.BACKUP_DaVinciServer”.
16.09.2023 09:59 Reading the folder information: “resolve_project_server_config”.
16.09.2023 09:59 Uploading local “resolve_project_server_config202309161158.zip” to remote “resolve_project_server_config202309161158.zip” in folder “\Qnap\archiv\1.BACKUP_DaVinciServer\resolve_project_server_config”.
16.09.2023 09:59 Uploaded 100.00 % (average speed = 78,95 KB/s).
16.09.2023 09:59 Verifying remote file “resolve_project_server_config202309161158.zip” with local one “resolve_project_server_config202309161158.zip”.
16.09.2023 09:59 Sending backup of “Machine_DaVinci_Server” to “Folder” destination “\Qnap\archiv\1.BACKUP_DaVinciServer”.
16.09.2023 09:59 Reading the folder information: “Machine_DaVinci_Server”.
16.09.2023 09:59 Uploading local “Machine_DaVinci_Server202309161158.zip” to remote “Machine_DaVinci_Server202309161158.zip” in folder “\Qnap\archiv\1.BACKUP_DaVinciServer\Machine_DaVinci_Server”.
16.09.2023 09:59 Uploaded 100.00 % (average speed = 261,09 MB/s).
16.09.2023 09:59 Verifying remote file “Machine_DaVinci_Server202309161158.zip” with local one “Machine_DaVinci_Server202309161158.zip”.
16.09.2023 09:59 Sending backup of “Project_Server” to “Folder” destination “\Qnap\archiv\1.BACKUP_DaVinciServer”.
16.09.2023 09:59 Reading the folder information: “Project_Server”.
16.09.2023 09:59 Uploading local “Project_Server202309161159.zip” to remote “Project_Server202309161159.zip” in folder “\Qnap\archiv\1.BACKUP_DaVinciServer\Project_Server”.
16.09.2023 09:59 Uploaded 100.00 % (average speed = 371 MB/s).
16.09.2023 09:59 Verifying remote file “Project_Server202309161159.zip” with local one “Project_Server202309161159.zip”.
16.09.2023 09:59 Sending backup of “postgres” to “Folder” destination “\Qnap\archiv\1.BACKUP_DaVinciServer”.
16.09.2023 09:59 Reading the folder information: “postgres”.
16.09.2023 09:59 Uploading local “postgres202309161159.zip” to remote “postgres202309161159.zip” in folder “\Qnap\archiv\1.BACKUP_DaVinciServer\postgres”.
16.09.2023 09:59 Uploaded 100.00 % (average speed = 419,56 KB/s).
16.09.2023 09:59 Verifying remote file “postgres202309161159.zip” with local one “postgres202309161159.zip”.
16.09.2023 09:59 Cleaning up backups of "Backup Job - 1 " job.
16.09.2023 09:59 Cleaning up backups of “resolve_project_server_config” database at “Folder” destination “\Qnap\archiv\1.BACKUP_DaVinciServer”.
16.09.2023 09:59 Cleanup of “resolve_project_server_config” completed.
16.09.2023 09:59 Cleaning up backups of “Machine_DaVinci_Server” database at “Folder” destination “\Qnap\archiv\1.BACKUP_DaVinciServer”.
16.09.2023 09:59 Cleanup of “Machine_DaVinci_Server” completed.
16.09.2023 09:59 Cleaning up backups of “Project_Server” database at “Folder” destination “\Qnap\archiv\1.BACKUP_DaVinciServer”.
16.09.2023 09:59 Cleanup of “Project_Server” completed.
16.09.2023 09:59 Cleaning up backups of “postgres” database at “Folder” destination “\Qnap\archiv\1.BACKUP_DaVinciServer”.
16.09.2023 09:59 Cleanup of “postgres” completed.
16.09.2023 09:59 Disconnecting from “Folder” destination “\Qnap\archiv\1.BACKUP_DaVinciServer”.
16.09.2023 09:59 Deleting temporary files.
16.09.2023 09:59 Job "Backup Job - 1 " finished.

Hello Holle,

To investigate this case, we require more details. Could you please provide us with screenshots of your backup jobs’ settings or share your job configuration (“Tools” > “Configuration Manager” > “Export”)? You can send the configuration to support@sqlbackupandftp.com.

If you have any other questions, please let us know.

Thank you, and we apologize for any inconvenience.

Hi Alex i´m out of office for a few weeks. I´ll try to get somebody to do the screenshots and send them to your email address.

best regards

Hello Holle,

Sure, thank you!

Hi there, stupid me just realized that we actually do backup 4 Databases it seems. I thought it was one. That explains why a manual backup worked, a scheduled one not. What still wonders me is, why scheduled backups worked for over a month. We bought a lite license now. Let´s see if the next scheduled backup will go through…

best
H.

Hello Burningheart_Film_un,

Great news! Thank you for the update.

Should you have any questions or concerns, please feel free to contact us.

Hello Muhamed_Smajli,

It seems you try to backup your remote SQL Server using the local SQL Server connection. To resolve the issue, please try to install SQLBackupAndFTP on the same server where SQL Server is installed or use the remote connection. Please find more details about the remote backups at:

https://sqlbackupandftp.com/blog/remote-sql-server-backups-explained

If you have any other questions, please let us know.

Thank you for using SQLBackupAndFTP.