Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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?

asked 29 Apr '13, 12:50

RobertDD's gravatar image

accept rate: 42%

edited 29 Apr '13, 14:47

Mark%20Culp's gravatar image

Mark Culp

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.)

(30 Apr '13, 04:54) Volker Barth

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 )

permanent link

answered 29 Apr '13, 18:25

Jeff%20Albion's gravatar image

Jeff Albion
accept rate: 25%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 29 Apr '13, 12:50

question was seen: 2,772 times

last updated: 30 Apr '13, 04:54