My db got corrupted yesterday. The problem is that when I
login to my ASP application, it stops the db. I tried
troubleshooting yesterday, but i can't figure this out.
I have a complete backup of a database from last week which
runs fine. If I take the backup db file and somehow
associate or apply the transaction file of the corrupted db,
can I recover all the transactions that have been going on
since last week?

If so, please let me know how to apply the latest
transaction file to the old backup copy of the db.

Thanks

Forgot to mention that I'm using Sybase SQL Anywhere 9.0.2

You will use the -a engine switch to apply the transaction log. You must
start with a copy of the backup that has not be started since the backup
(otherwise the transaction log offsets would have changed)

From the product docs:

ASA Database Administration Guide
Backup and Data Recovery
Backup and recovery tasks
Recovering from media failure on the database file

You may want to revisit your backup and recovery plan, once you get past
this issue, and address any deficiencies discovered.

-chris




John Ashmore wrote:

OK, thanks.
Can you please give me the whole command line to do this?

Let's say the backup db is here:
D:\backup\dbfile.db
The latest and corrupted db file and transaction log are
here:
d:\latest\dbfilenew.db + dbfilenew.log
The sql anywhere program is installed here:
c:\sybase9

I suppose I first need to copy the dbfilenew.log to
d:\backup and then run the command line, right?

Thanks.

Assuming that you have only one transaction log, the process is:

1. Create a recovery directory
2. Copy the backup database to that directory
3. Copy the current transaction log (the one that was in use by the
damaged database.
4. Run the following command:

dbeng9 -n RecoveryEng dbfile.db -a dbfilenew.log

John Ashmore wrote:

Great, it worked!

Thanks!