How to troubleshoot a db crash?

[Former Member]

This morning I had my primary SQL 12 database disappear on me. The machine did not go down or anything, the database just disappeared.

This happened before I came into work, so some team members restarted the database and when I came in I backed up the log files that were available on the machine from around the time of the "crash".

I have no idea how to troubleshoot what happened. I translated the log file, but it doesn't seem to give me anything useful. Were would you start if you were in my position?

[VolkerBarth]

Do you have a console log file (dbsrv12 -o MyLog.txt) of the server - and if so, does it reveal anything around the time of the crash?

(And if you don't have used -o so far, I'd highly recommend that option.)

[jeff_albion]

Hi Robert,

Which operating system is this on? Check the system log. Do you see any system log entries around the time you suspect the crash happened? (either in the Microsoft Windows Event log, syslogd on Linux/Unix?)

Open a Command Prompt/Terminal/Console , and type: dbsupport -lc - do you see any unsubmitted submission reports listed? If you do, type dbsupport -sa to submit them to us. If you wish to find out more detailed information, you should open a technical support case with these submission reference numbers.

Which build of SQL Anywhere are you running? ( dbsrv12 -v )