So.... are you saying that when we choose:
Catalog Backup
- test integrity
- optimize catalog after backing up
that these steps aren't sufficient for the SQLite DB? That we should also periodically run the generic SQLite utility? If so, this sounds like Adobe has really given us a sense of false security.
So far, only backups are affected. The catalogue in use seems to be fine and should be backed up by other means, as pointed out by Frank.
As far as I know, the only thing that gets done as part of the Lightroom automated backup is to zip the catalogue file. Not sure what one can mess with such a simple workflow. Now, obviously, if they do this too early while the database is in use and still has a lock on it...
I don't know if it makes sense to keep on doing the Lightoom backup to trigger the optimisation of the catalogue in use. I have disabled it in the meantime. Who knows, maybe the optimisation is nothing more than running the SQLite utility in repair mode?
Cheers,
Fabien