The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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

RobertDD
489161719
accept rate: 42%

edited 29 Apr '13, 14:47

Mark%20Culp's gravatar image

Mark Culp
22.3k9129262

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
10.7k171174
accept rate: 24%

Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×404
×43
×30
×11

question asked: 29 Apr '13, 12:50

question was seen: 822 times

last updated: 30 Apr '13, 04:54