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.
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
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
Note: the -ad, -ar, and -as switches were not added until SQL Anywhere 10.
answered 10 Dec '09, 22:01