(Show Contents)

How to Recover Project Data from a Log File (Sybase)

If you had a failure of your database server since your last backup, or if your database file has become corrupted, you will need to restore your previous database backup and apply the log file of more recent changes to that database. To do this:

1. Stop your database server.
2. Archive the corrupted database file and the current log file.
3. Convert the current log file into SQL statements in a .SQL file. Do so using the Sybase Central program’s "Translate Log" utility. When selecting options, in general you will want to disallow uncommitted transactions, generate for all users, and include trigger-generated transactions.
4. Restore the back-up database. Delete and restart its log file using the Sybase Central "Change Log File Information" utility.
5. Restart the server, only now using the back-up database.
6. Apply the SQL file representing the log file contents to the server. To do so, use the Sybase Central "Interactive SQL" utility. Log onto the server as the database administrator (the default account is "DBA" and default password is "SQL"). Use the File/Open command to load the .SQL file, and the Command/Execute command to run it.

For more information on this topic, please refer to the online User’s Guide of Adaptive Server Anywhere.