SQL Prompt 11

SQLite database corruption (SQL History)

In some cases, SQL Prompt's local SQLite database (used for SQL History) may become corrupted. This can lead to issues such as loading query history,  missing history entries, or errors such as "database disk image is malformed."

The SqlHistory.db file is located within the SQL Prompt data folder under your local AppData directory (AppData\Local\Red Gate\SQL Prompt 11)

warning Important

Deleting or resetting the SQL history database will result in permanent loss of stored query history.

Attempt Recovery 

Recovery is not guaranteed and may only restore partial data.



Didn't find what you were looking for?