Log File - Assertion Failed

[former_SQLA_member1694872]

How to extract data from a log file.

It is to do this ?! My database showed error Assertion Failed.

[VolkerBarth · Accepted solution]

You can use the builtin DBTRAN utility to translate the log (possibly using -j to start at a particular checkpoint) into a script with the according SQL statements.

I'd like to add that you should check whether your database file has become corrupt - not every assertion means a corrupt database. And if it seems corrupt, you usually should be able to apply the current log to your last backup... - that would prevent the need to "manually" re-apply operations... (or only those that had not been committed but were rollbacked when the assertion happened by making use of DBTRAN -a).

[VolkerBarth · Accepted solution]

Oops, why does my answer misses the "edit" button?

Ah, navigating to another page and back brings back the "edit" button.

[former_SQLA_member1694872 · Accepted solution]

The user started the last backup using the -f command line it can not apply log file. He started the last backup and made entries in the system. when I

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C: \\ Users \\ walmir> dblog -tc: \\ db \\ sis.log c: \\ db \\ sis.db

SQL Anywhere Transaction Log Utility Version 12.0.1.3152
"c: \\ db \\ sis.db" was using log file "sis.log"
"c: \\ db \\ sis.db" is using the mirror log file
"c: \\ db \\ sis.db" is now using log file "c: \\ db \\ sis.log"
Transaction log starting offset is 0945518960
Transaction log current relative offset is 0000286142

C: \\ Users \\ walmir>

not in error,

but when I

displays error Assertion Failed

[VolkerBarth · Accepted solution]

Hm, I'm not sure what you have tried to do - why do you change the location of the log file?

In case a database has to be recovered without using a log file (i.e. dbeng9 -f), then it should shutdown afterwards and will create a new (empty) log file during the next normal start automatically...