Local database of backup job fails to restore

The local database of my daily backup job was corrupted and the UI notified me to repair.
The repair failed with the notification to list-broken-files and purge-broken-files.
The commands returned with code 0 (success I guess).
But trying to start the backup notified me again to repair the database.
This seemed to be an endless loop.

So I tried several times to restore (delete and repair) the database with the UI.

This didn’t succeed and I get the following error messages:
“2025-12-09 08:26:42 +01 - [Error-Duplicati.Library.Main.Controller-FailedOperation]: The operation Repair has failed\r\nDatabaseInconsistencyException: Detected 18 volumes with missing filesets”

“2025-12-09 19:00:06 +01 - [Error-Duplicati.Library.Main.Controller-FailedOperation]: The operation Backup has failed\r\nUserInformationException: The database was attempted repaired, but the repair did not complete. This database may be incomplete and the backup process cannot continue. You may delete the local database and attempt to repair it again.”

I’m using Duplicati 2.2.0.1_stable_2025-11-09 on Windows 11.
The backup has been created initially with an older version but worked fine for several weeks with the new version.

So, is there a chance to reactivate the backup job with all the archive data versions?
And how would I do that?

I see also the following messages when trying to recreate the local database:
File not found: Could not find file ‘\?\P:\Backup\duplicati-b9d28c6dff7aa4ca098deec7579dadf46.dblock.zip.aes’.
"2025-12-11 00:22:13 +01 - [Error-Duplicati.Library.Main.Controller-FailedOperation]: The operation Repair has failed\

Replaced blocks for 116 missing volumes; there are now 115 missing volumes

Do I get it right that according to this explanation Explaining the local database I have the worst case szenario with some missing files at the remote storage so that it is impossible to recreate the local database?

Although I might use the recovery tool to access whats left on my archive drive?

So as I have one cloud and one local media backup still working, I simple would use a fresh archive drive to replace the corrupted drive for the third backup job?