[ncza]

Does a simple VACUUM prevent this?

[delinka]

Based on the description at [1] it does indeed seem logical that a VACUUM would prevent this type of recovery on primary databases.

1 - https://sqlite.org/lang_vacuum.html