On Dec 30, 2:08 pm, Alex <[email protected]> wrote: > Hello Thomas, > > As a follow-up question... > What is supposed to happen when the database is open if the index file > was deleted, but the transaction log contains some data referring to > the deleted index file ?
Try this:: 1. backup your files (don't skip this step) 2. delete the index file 3. delete the log file 4. connect to the database Hopefully that will get the database up and running again. My guess is what is happening is the log file is causing the start up to fail because you used log=2, and the index file was deleted. If the above steps work make sure you have a script of the database so that you can recreate the database in the future if it get's corrupted again. Example: script to '~/backups/mydatabase.sql'; I hope that helps. Brish --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
