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? |
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: Which build of SQL Anywhere are you running? ( answered 29 Apr '13, 18:25 Jeff Albion |
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.)