Once I experienced a problem during testing where multi-threaded Win32 Application (using SQLite 3.3.4) was running (in development environment) and due to power-failure, rollback journal file was OK but disk bad-sector damaged the sqlite db-file.
When I restarted App, db could not be opened (data file was probably corrupted), So I tried to copy db-file to another place and it could not copy (due to disk bad-sector). (I guess, at the time of power-failure, my app may be writing to db-file (after rollback generation) exactly that same moment of power failure, which caused bad sector in disk db-file and db-file got corrupted, so could not be rolled back while opened for the next time). I needed to get copy of db-file from previous night backup. (As hardware failure (bad-sector), does not left us many choices). Rohit -- View this message in context: http://www.nabble.com/Recovery-tool---tf2071432.html#a5737892 Sent from the SQLite forum at Nabble.com.
