What exactly does the Integrity Check do? I have never gotten anything but OK.
IF the built in command integrity_check command is used it checks for
Out-of-order records
Missing pages:
Malformed records:
Missing index entries:
UNIQUE and NOT NULL constraint errors:
If the database is found to be in a consistent state, the command will return 'ok'
adding to what BobC said
“Regular maintenance: Integrity checks should be part of a regular maintenance schedule for all databases, even those not considered critical”
its probably a good idea to run Integrity & rebuild indexed on a regular bases – the other two are less important but can improve performance and maybe make a slight smaller database
Integrity check has been confirmed by RM Inc to be the same as the SQLite command
PRAGMA integrity_check
It checks everything at the database level.
It can’t check the logical correctness of the data within the database.
What are your options if you do not get an OK?
Establishing a solid backup strategy is far more important for data integrity than relying on frequent integrity checks for prevention.
You can run the tools one more time, and if it doesn’t clear after, that the option is to restore a backup.