-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 11/12/12 03:46, dd wrote: > But in customers place, I am getting corruptions.
Chances are that whatever corrupts your databases would also corrupt the backups. Here is something the Windows team found: http://blogs.msdn.com/b/oldnewthing/archive/2005/04/12/407562.aspx > But, critical data is there with corrupted database. How can I recover > it without backup. You can't without a backup unless the corruption happened in duplicate information (eg an index). > Any sample application for virtual table option. You'll probably find that quite hard. A simpler alternative is to temporarily attach another database and copy the table into it. attach 'backup.db' as backup; drop table if exists backup.important; create table backup.important as select * from important; detach backup; Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAlDHdLIACgkQmOOfHg372QTEjgCdGcoBgu9u5d55NuSoIsl57WWr pqYAoMWjFW0UhM0i8tsRCqRznV8Irh5u =03Xw -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users