Server Cannot Find the Transaction Log

If the server fails to start because it cannot find the transaction log, messages appear in the server log file.

The following messages appear:
Transaction log: /dbdir/dbname.log...
Error: Cannot open transaction log file 
-- No such file or directory
Cannot open transaction log file 
-- No such file or directory

If this error is reported when you attempt to start the server, find the transaction log file and copy the file to the same directory as the database .db file. If you cannot find the correct transaction log file, then restore from the last valid backup.

If no other option for starting the server is available, you may be able to start the server using the emergency recovery -f option. Contact Sybase Technical Support for assistance, if necessary.

Warning!  This procedure is highly risky and is not recommended except in extreme cases.