Corrupt transaction log; Build a new ASE transaction log with dbcc rebuild_log
In some cases it is necessary to rebuild the ASE transaction log.
Sybase Technical Support states that this is extremely dangerous. It may cause potential database corruption if the system fails while the timestamp rolls over.
dump the database first. If “dbcc rebuild_log” corrupts the database [...]
How to mark a database as suspect
It might become necessary to drop a database, because it is unaccessible after loading a corrupt dump.
Please note that you should only follow these steps at your own risk, as you might loose the data in your database. Do not try this on critical databases.
The task can be done [...]
There is an undocumented dbcc command in ASE starting with v12.5.4 ESD#1 and v15.0.2, to manipulate one or many databases on a single dataserver. This is helpful, if for example a database cannot be loaded due to zombie processes holding a lock on the database, resulting in “Database in use”-errors when no-one is actually using [...]