On 7 Mar 2012, at 11:22am, Marcus Grimm <mgr...@medcom-online.de> wrote:
> I evaluating the need to issue a (timeconsuming) "pragma integrity_check" > prior > running the backup to avoid that a backup will be overwritten > with an invalid database. Did you know about <http://www.sqlite.org/pragma.html#pragma_quick_check> ? It misses out a check, but the check it misses out is for data which can be recovered simply by recreating corrupt indexes. On the other hand, if you are using this as a warning system that corruption has occurred and therefore you may have faulty hardware, then the more thorough the check, the better. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users