I create a db without transaction protected.Then i insert
100000 items in it.After that i delete 10000 items in it.
It is work well if i close the application normally.And it
often work well after the application crash(i use the vc.net to debug
the application and push the stop debug button).But some time it work
fail(i open the db sussessful. But when i access the db it throw a
exception).I exit the application and run the db_verify.exe
utilities.it report that invailed ××pgno and DB_VERIFY_BAD .
My questions are :What can i do with this database(how to repair
it)?How can avoid it(because it happen some time not all the time)?

* demon:

db_dump can recover what's still there, but the data might not be
consistent.

Perhaps you can use SEH on Windows, but I wouldn't be surprised if all
bets were off when you use a debugger. To guard your data in such
cases, you need to use the transactional data store.

Florian Weimer wrote:
To Florian Weimer:
Thanks for reply me!As you say i used db_dump with R option.But it
report same as db_verify.And it create a file. I use the created file
as my operation db.But it fail as not use db_dump.