Folder Backups failing due to files being in use

Hello,

We are facing an issue with Folder backups when the users are using some of the files in the folders:

ERROR: Failed to backup “XYZ” folder in D:\XYZ. 7-zip archiver error. > (1) 7-Zip 18.05 (x64) : Copyright © 1999-2018 Igor Pavlov : 2018-04-30 Scanning the drive: 652 files, 2208523763 bytes (2107 MiB) Creating archive: D:\Temporary Folder\Pranas.NET\SQLBackupAndFTP\backup\XYZ201906041409.7z Add new data to archive: 652 files, 2208523763 bytes (2107 MiB) Files read from disk: 651 Archive size: 1988807682 bytes (1897 MiB) WARNINGS for files: D:\XYZ~$filename.xlsx : The process cannot access the file because it is being used by another process. WARNING: Cannot open 1 files…

Since we are backing up this folder throughout the day and sometimes the users leave these files opened on the production servers as well, this folder backup is mostly failing.

It would be great if this problem is solved and the backups can be done even when certain files are in use.

Hello,

Thank you for the details.

We plan to add to 7zip archive the option that will allow archiving the files that are open in other applications. That option will be available for back up local files and folders.

Sorry for the inconvenience.

Hello PRESS_FIT_PIPE_AND_P,

That changes were added to the latest release of SQLBackupAndFTP https://sqlbackupandftp.com/download Could you please install it and check if it works.

Sorry for the inconvenience.

Hello,

It doesn’t seem to have been rectified. We are on the latest patch but we got the error today due to an open file.

Hi PRESS_FIT_PIPE_AND_P,

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.

Hello,
Today, we didn’t get the same error today. We are still checking. But we got a different one:

05-11-2019 12:13:08 [Error] Failed to backup “SAP Files” folder in D:\SAP Files. 7-zip archiver error. > (1)
7-Zip 18.05 (x64) : Copyright © 1999-2018 Igor Pavlov : 2018-04-30

Scanning the drive:
4 folders, 5451 files, 1746141596 bytes (1666 MiB)

Creating archive: F:\SAP Daily Backup\Temporary Folder\Pranas.NET\SQLBackupAndFTP\backup\SAP Files201911051211.7z

Add new data to archive: 4 folders, 5451 files, 1746141596 bytes (1666 MiB)

Files read from disk: 5423
Archive size: 532095964 bytes (508 MiB)

WARNINGS for files:

D:…~$GRP ghumne waali live file minus repalcement.xlsx : The filename, directory name, or volume label syntax is incorrect.

WARNING: Cannot open 1 file. Error:
WARNING: The filename, directory name, or volume label syntax is incorrect.
D:…~$GRP ghumne waali live file minus repalcement.xlsx

Can you tell me if this error is related? Even if not, what can be done to prevent this?

PRESS_FIT_PIPE_AND_P

We have checked this issue, sorry, but it cannot be resolved from our side. The issue is related to the peculiarity of 7zip operation, we recommend you to try different settings for 7zip. Perhaps there are parameters which allow ignore a file with that name.

SQLBackupAndFTP

Sorry for the inconvenience.