Using 11.2.4 Free edition.
backup destination is SFTP.
Backup job is failing just because it could not cleanup old backups.
Log:
10/24/2017 2:50 AM Starting job “new.jobx” with backup type “Full”. The computer name: “RSRVR”. The application version: “11.2.4”
10/24/2017 2:50 AM The backup folder of the job is “D:\xyz\Setup\Pranas.NET\SQLBackupAndFTP\backup” with “3153.275GB” free space. The temporary folder of the job is “D:\xyz\Setup\Pranas.NET\SQLBackupAndFTP\backup” with “3153.275GB” free space
10/24/2017 2:50 AM Backing up “.” SQL Server databases
10/24/2017 2:50 AM Getting maximum file size…
10/24/2017 2:50 AM The maximum file size: “”
10/24/2017 2:50 AM Backing up “xyz” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
10/24/2017 2:52 AM “xyz” database backup successfully completed. Backup type: “Full”
10/24/2017 2:52 AM Database “xyz” has been successfully backed up to “xyz201710240250.bak : 8.345GB”
10/24/2017 2:52 AM Compressing “xyz201710240250.bak” file with Internal archiver. Encryption: “Off”
10/24/2017 3:01 AM Backup of “xyz” has been successfully compressed to “(xyz201710240250.zip : 1.216GB)”
10/24/2017 3:01 AM Backing up “xyz_audit” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
10/24/2017 3:03 AM “xyz_audit” database backup successfully completed. Backup type: “Full”
10/24/2017 3:03 AM Database “xyz_audit” has been successfully backed up to “xyz_audit201710240301.bak : 5.126GB”
10/24/2017 3:03 AM Compressing “xyz_audit201710240301.bak” file with Internal archiver. Encryption: “Off”
10/24/2017 3:08 AM Backup of “xyz_audit” has been successfully compressed to “(xyz_audit201710240301.zip : 589.815MB)”
10/24/2017 3:08 AM Connecting to FTP destination “host525.xyz.com”
10/24/2017 3:08 AM The current folder of the destination is “Clients/xyz”
10/24/2017 3:08 AM Sending backup of “xyz” to FTP destination “host58.xyz.com”
10/24/2017 3:08 AM Uploading the local file “xyz201710240250.zip” into a remote file “xyz201710240250.zip”
10/24/2017 3:08 AM Uploaded 100 % (average speed = 0 B/s)
10/24/2017 3:15 AM Verifying remote file “xyz201710240250.zip” with local one “xyz201710240250.zip”
10/24/2017 3:15 AM Disconnecting from FTP destination “host58.xyz.com”
10/24/2017 3:15 AM Connecting to FTP destination “host58.xyz.com”
10/24/2017 3:15 AM The current folder of the destination is “Clients/xyz”
10/24/2017 3:15 AM Sending backup of “xyz_audit” to FTP destination “host58.xyz.com”
10/24/2017 3:15 AM Uploading the local file “xyz_audit201710240301.zip” into a remote file “xyz_audit201710240301.zip”
10/24/2017 3:16 AM Uploaded 100 % (average speed = 0 B/s)
10/24/2017 3:19 AM Verifying remote file “xyz_audit201710240301.zip” with local one “xyz_audit201710240301.zip”
10/24/2017 3:19 AM Disconnecting from FTP destination “host58.xyz.com”
10/24/2017 3:19 AM Cleaning up backups of “new.jobx” job
10/24/2017 3:19 AM Cleaning up backups of “xyz” database at FTP destination "host58.xyz.com"
10/24/2017 3:19 AM Destination error: No such path; The file path does not exist or is invalid.
10/24/2017 3:19 AM Destination error: No such path; The file path does not exist or is invalid.
10/24/2017 3:19 AM Destination error: No such path; The file path does not exist or is invalid.
10/24/2017 3:19 AM Destination error: No such path; The file path does not exist or is invalid.
10/24/2017 3:19 AM Failed to clean up backups of “new.jobx” job: [DST-2:1100#1] Failed to get “Clients/xyz” folder information. > No such path; The file path does not exist or is invalid.
10/24/2017 3:19 AM Clients/xyz not found on the destination.
10/24/2017 3:19 AM Destination error: Could not find source path (’/Clients/xyz/Clients/xyz’).
10/24/2017 3:19 AM Destination error: Could not find source path (’/Clients/xyz/Clients/xyz’).
10/24/2017 3:19 AM Destination error: Could not find source path (’/Clients/xyz/Clients/xyz’).
10/24/2017 3:19 AM Destination error: Could not find source path (’/Clients/xyz/Clients/xyz’).
10/24/2017 3:19 AM Failed to clean up backups of “new.jobx” job: [DST-2:1106#1] Failed to search files on folder “Clients/xyz” with mask "xyz.*". > Could not find source path (’/Clients/xyz/Clients/xyz’).*
10/24/2017 3:19 AM Job “new.jobx” finished with “1” errors
10/24/2017 3:19 AM Sending job log to bkup@xyz.com
Hello,
Thank you for the issue reporting.
This is known issue and we are working to fix it.
Sorry for the inconvenience.
When new version will release ? approx ?
We plan to release a new version till the end of this week.
Hello,
We have just released SQLBackupAndFTP version 11.3.0
Please make sure that you use the latest version of SQLBackupAndFTP and check if it solves the issue?
If your SQLBackupAndFTP hasn’t been updated automatically you can do it by clicking “Help” > “Check for Update”.
I installed new version
after that 1 error popped up, I have attached screenshot “Screenshot1”
I just lost all configuration. Attached “screenshot2”
When i click on job it gives error. “screenshot3”
Thank you for the feedback.
We were able to reproduce this issue, and it will be fixed in a couple of hours. Sorry for the inconvenience.
1 Like
We have fixed this issue. Could you please install SQLBackupAndFTP version 11.3.1 and check if it solves the issue?
Sorry for the inconvenience.
That error solved but old file deletion problem continues.
Below is log :-
11/2/2017 1:25 AM Starting job “Backup Job - 1” with backup type “Full”. The computer name: “PK-xyz”. The application version: “11.3.1”
11/2/2017 1:25 AM The backup folder of the job is “C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup” with “58.102GB” free space. The temporary folder of the job is “C:\WINDOWS\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup” with “58.102GB” free space
11/2/2017 1:25 AM Backing up “.” SQL Server databases
11/2/2017 1:25 AM Getting maximum file size…
11/2/2017 1:25 AM The maximum file size: “”
11/2/2017 1:25 AM Backing up “xyz_db50” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
11/2/2017 1:38 AM “xyz_db50” database backup successfully completed. Backup type: “Full”
11/2/2017 1:38 AM Database “xyz_db50” has been successfully backed up to “xyz_db50201711020125.bak : 6.535GB”
11/2/2017 1:38 AM Compressing “xyz_db50201711020125.bak” file with Internal archiver. Encryption: “Off”
11/2/2017 1:57 AM Backup of “xyz_db50” has been successfully compressed to “(xyz_db50201711020125.zip : 750.748MB)”
11/2/2017 1:57 AM Backing up “xyz_db50_Audit” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
11/2/2017 2:02 AM “xyz_db50_Audit” database backup successfully completed. Backup type: “Full”
11/2/2017 2:02 AM Database “xyz_db50_Audit” has been successfully backed up to “xyz_db50_Audit201711020157.bak : 1.774GB”
11/2/2017 2:02 AM Compressing “xyz_db50_Audit201711020157.bak” file with Internal archiver. Encryption: “Off”
11/2/2017 2:06 AM Backup of “xyz_db50_Audit” has been successfully compressed to “(xyz_db50_Audit201711020157.zip : 204.769MB)”
11/2/2017 2:06 AM Connecting to FTP destination “host123.xyz.com”
11/2/2017 2:06 AM The current folder of the destination is “Clients/path”
11/2/2017 2:06 AM Sending backup of “xyz_db50” to FTP destination “host123.xyz.com”
11/2/2017 2:06 AM Uploading the local file “xyz_db50201711020125.zip” into a remote file “xyz_db50201711020125.zip” on the remote folder “Clients/path”
11/2/2017 2:06 AM Uploaded 100 % (average speed = 950.5 KB/s)
11/2/2017 2:19 AM Verifying remote file “xyz_db50201711020125.zip” with local one “xyz_db50201711020125.zip”
11/2/2017 2:19 AM Disconnecting from FTP destination “host123.xyz.com”
11/2/2017 2:19 AM Connecting to FTP destination “host123.xyz.com”
11/2/2017 2:19 AM The current folder of the destination is “Clients/path”
11/2/2017 2:19 AM Sending backup of “xyz_db50_Audit” to FTP destination “host123.xyz.com”
11/2/2017 2:19 AM Uploading the local file “xyz_db50_Audit201711020157.zip” into a remote file “xyz_db50_Audit201711020157.zip” on the remote folder “Clients/path”
11/2/2017 2:19 AM Uploaded 100 % (average speed = 1022.1 KB/s)
11/2/2017 2:23 AM Verifying remote file “xyz_db50_Audit201711020157.zip” with local one “xyz_db50_Audit201711020157.zip”
11/2/2017 2:23 AM Disconnecting from FTP destination “host123.xyz.com”
11/2/2017 2:23 AM Cleaning up backups of “Backup Job - 1” job
11/2/2017 2:23 AM Cleaning up backups of “xyz_db50” database at FTP destination "host123.xyz.com"
11/2/2017 2:23 AM Destination error: Could not find source path (’/Clients/path/Clients/path’).
11/2/2017 2:23 AM Destination error: Could not find source path (’/Clients/path/Clients/path’).
11/2/2017 2:23 AM Destination error: Could not find source path (’/Clients/path/Clients/path’).
11/2/2017 2:23 AM Destination error: Could not find source path (’/Clients/path/Clients/path’).
11/2/2017 2:23 AM Failed to clean up backups of “Backup Job - 1” job: [DST-2:1106#1] Failed to search files on folder “Clients/path” with mask "xyz_db50.*". > Could not find source path (’/Clients/path/Clients/path’).*
11/2/2017 2:23 AM Job “Backup Job - 1” finished with “1” errors
11/2/2017 2:23 AM Sending job log to backup@xyz.com
Any update on new release?
Hello,
Thank you for the details.
You use SQLBackupAndFTP version 11.3.1 could you please update it to version 11.3.2 and check if it solves the issue?
Sorry for the inconvenience.
Still same issue persist.
Hello,
Thank you for the feedback. Please give us some time to check it. Sorry for the inconvenience.
Could you please make sure that you use SQLBackupAndFTP version 11.3.3. If you still have this issue please send us the Advanced log. You can find more details on how to send Advanced Log to developers at https://sqlbackupandftp.com/blog/how-to-send-log-to-developers
I can’t send log directly. because it revels server details. I use to edit server identity and database name in log and then i sent you. Is there any other way to send you advance log ?
Hello,
To make your logs private, please send them to support@sqlbackupandftp.com
Mail sent. Once you receive mail. reply confirmation.
Yes, thank you, we have received it. Please give us some time to check it.
Any update on above issue ?
