We found out yesterday that the backup of both the sql and sql express DB's had not been working. We are not exactly sure why.
There isn't anything in either log files that stands out as making it go into recovery mode.
Here is the part where it finds a problem starting up the DB.
2008-06-23 08:29:13.21 spid55 Starting up database 'KoochData'.
2008-06-23 08:29:13.21 spid55 Error: 9003, Severity: 20, State: 1.
2008-06-23 08:29:13.21 spid55 The log scan number (145:4893:239) passed to log scan in database 'KoochData' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
2008-06-23 08:29:13.21 spid55 Error: 3414, Severity: 21, State: 1.
2008-06-23 08:29:13.21 spid55 An error occurred during recovery, preventing the database 'KoochData' (database ID 8) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
Before that was a bunch of messages that show the state of the DB. Like emergency mode, single user mode, and multi user mode. That was from me exucuting the code from the first thread.
I wanted to get it out of suspect mode and read online the way to do that was to change to emergency mode. I was trying to get to a point where I could run dbcc.
Do you know of any good recovery software?