I loose my database file. To recovery, I'm getting last full backup and trying to apply the only one transaction log backup and current log. I'm using dbeng9 database.db -a backup_log.log I'm successfully appling backup log. I can see "Recovery Complete" message in server log. But, when I try to apply current log, I', getting this message: How can I recover by database? Using dbtran and executing sql file is the last option. asked 09 Dec '09, 11:27 Zote Volker Barth |
I found my fault! I was missing an little log (16k with only 2 comments) between 1st and 2nd logs. answered 09 Dec '09, 15:42 Zote |
AFAIK if a database is modified and closed any previous transaction log will be "not matching". But you might try to apply both log files in one operation (untested): dbeng9 database.db -a backup_log.log -a current_log.log Another method would be using the -ad parameter: put all logfiles in one directory and specify that like dbeng9 database.db -ad "C:\Database\MyLogDir" The engine should scan the directory for transaction logs to apply and should process them in the appropriate order. Help Topic: "dbeng11, command line" answered 09 Dec '09, 11:52 Reimer Pods |
Note: the -ad, -ar, and -as switches were not added until SQL Anywhere 10. answered 10 Dec '09, 22:01 Josh Savill |
I found my fault! I was missing an little log (16k with only 2 comments) between 1st and 2nd logs. I think if sybase change message to something like 'waiting log with start offset XXXXX, current is YYYY' will help.
If you think that this topic can be closed, please vote for it.
I would suggest that you answer your own question (with the contents of your fist comment) and accept this (or Reimar's) answer as "preferred answer". That should close the case:)
@Volker nice, i'll do that.