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

Reply via email to