Storage:DetectingCorruption
Jump to navigation
Jump to search
- backup the database file you want to check
- install Storage Explorer from [1]
- start the browser, and from the Tools menu, select Storage Explorer
- select the database filename from the left-hand column
- in the text field on the right, do the following:
- type "vacuum", click the Execute Statement button
- clear the text field, type "pragma integrity_check", click the Execute Statement button
If the result is OK, then the database file is not corrupt (in a way sqlite can detect).