Thanks for answer. I can do integrity check by PRAGMA integrity_check.Please correct me if i wrong. Here backup means copying database file OR we can create query to SQLite for backup or copy.
Cheers- Techi On Wed, Jul 17, 2013 at 4:42 PM, Paolo Bolzoni < paolo.bolzoni.br...@gmail.com> wrote: > On Wed, Jul 17, 2013 at 12:55 PM, techi eth <techi...@gmail.com> wrote: > > 2) How do we make database safe from these error Or What is > Possibility to > > access database after error. > After error, as Stephan said you are out of luck. > > You should avoid this errors in the first place: > - make backup often, > - keep the safety features of sqlite3 on, > - use a error resilient filesystem (e.g., zfs), > - use ecc memory. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users