> > I've got a 500 mb database with one table that I set up to log system > > information over night and I arrive this morning to find this situation. > > The database was generated on windows using vbscript and the sqliteodbc > > driver based on sqlite 3.7.2. Do I have any hope of recovery? > > Probably not. I'll bet if you look at the database file beginning at page > 140481 you see that it has been overwritten with something that is not > database information, perhaps with all zeros. > > You can probably use the ".dump" utility to extract most or all of the > information prior to page 140481, though. So you can get some of your > database back. Have you tried that?
Thank you. That recovered 5.5 hours of data; or about 1/3 of the dataset. I can work with that. Ron Wilson, Engineering Project Lead (o) 434.455.6453, (m) 434.851.1612, www.harris.com HARRIS CORPORATION | RF Communications Division assuredcommunications(tm) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
