Database recovery can be a time consuming task, so does any tool exists, which give you information about the need to recover and also possibly about the extent of recovery which will be performed, like last checkpoint in relation to transaction logfile or so, without starting the database?
asked 26 Jul '13, 07:09
Attempting to start the database in read-only mode will tell you this information:
... but you will end up starting the database in read-only mode if it doesn't require recovery.
answered 26 Jul '13, 09:45
If you try to disable the transaction log (dblog -n foo.db) for a database that requires recovery, it will fail with the message "Database quit abnormally last time it was used. Database recovery must be performed before proceeding."
However, you MUST remember to enable the log again if you successfully disable it!
Jeff's suggestion of using read-only mode is probably safer.
answered 27 Jul '13, 07:53