SQLite database file is corrupt

Purpose

A database file has been corrupted and some of the data is unavailable.

Resolution

The database file appears to have some corruption, this can happen due to disk or network issues, or because of a power failure.

If you are running version 18.1.38.0 or later, you can repair your database by running the relevant command in an administrative PowerShell window:

pdqinventory RepairDatabase
pdqdeploy RepairDatabase

If repairing doesn't work, you can also try rolling back to a database backup:

pdqinventory RestoreDatabase
pdqdeploy RestoreDatabase

If none of that helps, contact us at support@pdq.com.

Still have a question or want to share what you have learned? Visit our Community Discord to get help and collaborate with others.