Backup is sendet to folder destination but then dissapeared

Application issues
1

Hi all,

I run a backup as followed:

sql-database “easybusiness” to folder “Backup_JTL”.
folder “\DC-SV\Backup” as .zip-file to folder “Backup_JTL”

As my report says everything is working fine (see below) … but there is no .zip-file in the folder “Backup_JTL”

My Auto delete time is set to 1 month 2 days.

Can you help me?

Here is the report:

Detailed Log:

  • 19:53:00 : Starting scheduled job "Backup JTL-DB" - "Full". Computer "SRVSQL". Account "Stefan Frank@FRANK". App v."12.2.10".
  • 19:53:00 : Connecting to SQL Server: 2014 RTM Express Edition (64-bit). SRVSQL\SQLEXPRESS
  • 19:53:00 : The backup folder "C:\Backup_JTL" has "353,695GB" free space. The temporary folder "C:\Backup_JTL" has "353,695GB" free space
  • 19:53:00 : Backing up "SRVSQL\SQLEXPRESS" SQL Server databases
  • 19:53:00 : Getting maximum file size…
  • 19:53:00 : The maximum file size: ""
  • 19:53:01 : Backing up "ReportServer$SQLEXPRESS" database to .bak file. Backup type: "Full". Checksum: "Enabled".
  • 19:53:01 : "ReportServer$SQLEXPRESS" database backup successfully completed. Backup type: "Full".
  • 19:53:01 : Database "ReportServer$SQLEXPRESS" successfully backed up to "ReportServer_SQLEXPRESS201910151953.bak : 4,345MB"
  • 19:53:01 : Backing up "ReportServer$SQLEXPRESSTempDB" database to .bak file. Backup type: "Full". Checksum: "Enabled".
  • 19:53:01 : "ReportServer$SQLEXPRESSTempDB" database backup successfully completed. Backup type: "Full".
  • 19:53:01 : Database "ReportServer$SQLEXPRESSTempDB" successfully backed up to "ReportServer_SQLEXPRESSTempDB201910151953.bak : 2,649MB"
  • 19:53:01 : Backing up "eazybusiness" database to .bak file. Backup type: "Full". Checksum: "Enabled".
  • 19:53:08 : "eazybusiness" database backup successfully completed. Backup type: "Full".
  • 19:53:08 : Database "eazybusiness" successfully backed up to "eazybusiness201910151953.bak : 493,299MB"
  • 19:53:08 : Backing up folders
  • 19:53:08 : Backing up "Backup" folder in [\DC-SV\Backup](file:///\DC-SV\Backup)
  • 19:53:08 : Compressing "[\DC-SV\Backup](file:///\DC-SV\Backup)" folder with Internal archiver. Encryption: "Off"
  • 20:51:58 : Backup of "[\DC-SV\Backup](file:///\DC-SV\Backup)" has been successfully compressed to "(Backup201910151953.zip : 37,397GB)"
  • 20:51:58 : Connecting to Folder destination "C:\Backup_JTL"
  • 20:51:58 : Reading folder information by path: "C:\Backup_JTL"
  • 20:51:58 : The current destination folder is "C:\Backup_JTL"
  • 20:51:58 : Sending backup of "ReportServer$SQLEXPRESS" to Folder destination "C:\Backup_JTL"
  • 20:51:58 : Uploading local "ReportServer_SQLEXPRESS201910151953.bak" to remote "ReportServer_SQLEXPRESS201910151953.bak" in folder "C:\Backup_JTL"
  • 20:51:58 : Uploaded 100 % (average speed = 312 MB/s)
  • 20:51:58 : Sending backup of "ReportServer$SQLEXPRESSTempDB" to Folder destination "C:\Backup_JTL"
  • 20:51:58 : Uploading local "ReportServer_SQLEXPRESSTempDB201910151953.bak" to remote "ReportServer_SQLEXPRESSTempDB201910151953.bak" in folder "C:\Backup_JTL"
  • 20:51:58 : Uploaded 100 % (average speed = 132,4 MB/s)
  • 20:51:58 : Sending backup of "eazybusiness" to Folder destination "C:\Backup_JTL"
  • 20:51:58 : Uploading local "eazybusiness201910151953.bak" to remote "eazybusiness201910151953.bak" in folder "C:\Backup_JTL"
  • 20:51:58 : Uploaded 100 % (average speed = 37,1 GB/s)
  • 20:51:58 : Sending backup of "Backup" to Folder destination "C:\Backup_JTL"
  • 20:51:58 : Uploading local "Backup201910151953.zip" to remote "Backup201910151953.zip" in folder "C:\Backup_JTL"
  • 20:51:58 : Uploaded 100 % (average speed = 2,8 TB/s)
  • 20:51:58 : Cleaning up backups of "Backup JTL-DB" job
  • 20:51:58 : Cleaning up backups of "ReportServer$SQLEXPRESS" database at Folder destination "C:\Backup_JTL"
  • 20:51:58 : Cleaning up backups of "ReportServer$SQLEXPRESSTempDB" database at Folder destination "C:\Backup_JTL"
  • 20:51:59 : Cleaning up backups of "eazybusiness" database at Folder destination "C:\Backup_JTL"
  • 20:51:59 : Cleaning up backups of "Backup" folder at Folder destination "C:\Backup_JTL"
  • 20:51:59 : Disconnecting from Folder destination "C:\Backup_JTL"
  • 20:51:59 : Job "Backup JTL-DB" finished
2

Hello Stefan_Frank,

To investigate this case, we need more details. Could you please send us the Advanced log? Here are more details on how to do it How to send Log to developers | SQLBackupAndFTP's blog

Please let us know when the log will be sent, also, please provide us with your Application ID (“Help” > “About”).

Also, could you please open your job log and click on the “Download Backup” button. To check if the backup will be downloaded?

SQLBackupAndFTP
SQLBackupAndFTP943×261 25.9 KB

Sorry for the inconvenience.

3

Hello Alexander,

thank you very much for your support! J

I sended the report via eMail

The download oft he file "Backup201910171800.zip " in folder "C:\Backup_JTL" does not work,

because the file does not exist (thats the problem: after uploading the file it is cleaned up immediately)

Another word about my settings: I selected the folder C:\Backup_JTL as Backup-Folder and additionally as Temporary folder.

But that should not be the problem, in my first trials with this setting the Backup of [\DC-SV\Backup](file:///\DC-SV\Backup) worked whithout problems.

I sended you our latest Report via eMail:

Thank you very much in advance;

Stefan

4

Hi Stefan_Frank,

Thank you. We have fixed this issue in the Alpha edition https://sqlbackupandftp.com/download/alpha Could you please install it and check if it works?

Sorry for the inconvenience.

5

Hi Alexander,
now it works! :slight_smile: Thank you very much!
Best regards,
Stefan

6

That’s great, Stefan! Thank you for your reply.

Please feel free to contact us on any issues or concerns.

7

I am having this same issue. I tried the alpha as well but it did not solve my issue.

Here are the logs… any help would be appreciated.

11/3/2019 1:57:33 AM [Info] Disconnecting from Folder destination “C:\backup”
11/3/2019 1:54:14 AM [Info] Starting job “PCHQ” - “Full”. Computer “HQ-SERVER”. Account “SYSTEM@WORKGROUP”. App v.“12.2.11”.
11/3/2019 1:54:14 AM [Info] Connecting to SQL Server: 2012 SP3 Express Edition (64-bit). .\SQLEXPRESS
11/3/2019 1:54:15 AM [Info] The backup folder “C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Backup” has “239.226GB” free space. The temporary folder “C:\Windows\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup” has “239.226GB” free space
11/3/2019 1:54:15 AM [Info] Backing up “.\SQLEXPRESS” SQL Server databases
11/3/2019 1:54:15 AM [Debug] Getting maximum file size…
11/3/2019 1:54:15 AM [Debug] The maximum file size: “”
11/3/2019 1:54:16 AM [Info] Backing up “PCHQ” database to .bak file. Backup type: “Full”. Checksum: “Disabled”.
11/3/2019 1:56:27 AM [Debug] “PCHQ” database backup successfully completed. Backup type: “Full”.
11/3/2019 1:56:27 AM [Info] Database “PCHQ” successfully backed up to “PCHQ201911030154.bak : 4.779GB”
11/3/2019 1:56:27 AM [Info] Connecting to Folder destination “C:\backup”
11/3/2019 1:56:28 AM [Debug] Reading folder information by path: “C:\backup”
11/3/2019 1:56:28 AM [Info] The current destination folder is “C:\backup”
11/3/2019 1:56:28 AM [Info] Sending backup of “PCHQ” to Folder destination “C:\backup”
11/3/2019 1:56:28 AM [Info] Uploading local “PCHQ201911030154.bak” to remote “PCHQ201911030154.bak” in folder “C:\backup”
11/3/2019 1:57:31 AM [Info] Uploaded 100 % (average speed = 77.2 MB/s)
11/3/2019 1:57:31 AM [Info] Verifying remote file “PCHQ201911030154.bak” with local one “PCHQ201911030154.bak”
11/3/2019 1:57:32 AM [Info] Cleaning up backups of “PCHQ” job
11/3/2019 1:57:32 AM [Info] Cleaning up backups of “PCHQ” database at Folder destination “C:\backup”
11/3/2019 1:57:32 AM [Info] Cleaning up “C:\backup” folder
11/3/2019 1:57:32 AM [Info] Deleting old backup of “PCHQ”. Backup type: “Full”. Backup time: “11/03/2019 01:57:31”. Files: “PCHQ201911030154.bak”
11/3/2019 1:57:33 AM [Info] Job “PCHQ” finished
8

Hello Stefanos_Tsartsalis,

Thank you for the details. We have added the changes to the Stable edition (SQLBackupAndFTP version 12.2.11) could you please install https://sqlbackupandftp.com/download it and check if it works?

Sorry for the inconvenience.