DLVS Backup Manager not cleaning old SQL/bak files

DLVS Backup Manager not cleaning old SQL/bak files

avatar

Hi,

I'm experiencing issues with the DLVS Backup Manager
That is unable to :

  1. verify backup
    1. Mail received :
      1. Backup validation failed
      2. Backup process completed. The system could not confirm that the file was created. Please verify manually.
  2. cleanup old backup
    1. I need to manually deleted old bak files


my setup:

1. An application server on witch runs the DevolutionsSchedulerService as the "local system account"
2. An MSSQL server

VM are running
Windows Server 2022
SQL Server Std 2022
DLVS 2024.1.6.0

SQL backup are setup to keep only 2 versions
The bak files are created correctly, the owner of the bak files is the "MSSQLSERVER" account


Thanks

All Comments (1)

avatar

Hi,

Thank you for your detailed information regarding the issues with the DLVS Backup Manager. It seems like the automatic cleanup process isn't executing as expected.

Ensure the DevolutionsSchedulerService has the necessary permissions on the destination folder to delete files. Sometimes, when running as a 'local system account,' it might lack the permissions required to delete the backup files created by the 'MSSQLSERVER' account. To test this, you can temporarily grant higher permissions or use an account that mirrors the permissions of the 'MSSQLSERVER'.

The database backup is always performed by the SQL service account. However, the files are deleted by the Scheduler Service account unless the backup job was started manually, in which case it would be the application pool identity.

If these steps do not resolve the issue, please feel free to provide additional details or logs, and we can investigate further.

Best regards,