v.23.9Improvement

Added restore setting restore_broken_parts_as_detached to handle broken parts during RESTORE process

Added restore setting restore_broken_parts_as_detached: if it's true the RESTORE process won't stop on broken parts while restoring, instead all the broken parts will be copied to the detached folder with the prefix `broken-from-backup'. If it's false the RESTORE process will stop on the first broken part (if any). The default value is false. #53877 (Vitaly Baranov).
Added a new restore setting restore_broken_parts_as_detached that allows the RESTORE process to continue despite broken parts by moving them to the detached folder with a prefix, instead of stopping the restore.

Why it matters

This feature addresses the issue where the RESTORE process would stop immediately upon encountering broken parts in the backup. By enabling this setting, users can avoid restore failures due to corrupted parts and handle them separately, improving the robustness and flexibility of data restoration.

How to use it

Set the restore_broken_parts_as_detached setting to true during the RESTORE operation to allow the process to skip broken parts and move them to the detached folder with the prefix broken-from-backup. By default, this setting is false, which causes the restore to stop on the first broken part.