Sybase Question:
Download Questions PDF

On startup, the transaction log of a database has filled and recovery has suspended, what can I do?


You might find the following in the error log:

00:00000:00001:2000/01/04 07:43:42.68 server Can't allocate space for object 'syslogs' in database 'DBbad' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase size of the segment.
00:00000:00001:2000/01/04 07:43:42.68 server Error: 3475, Severity: 21, State: 7
00:00000:00001:2000/01/04 07:43:42.68 server There is no space available in SYSLOGS for process 1 to log a record for which space has been reserved. This process will retry at intervals of one minute. The internal error number is -4.

Download Sybase Interview Questions And Answers PDF

Previous QuestionNext Question
Why do my page locks not get escalated to a table lock after 200 locks?How do I turn off marked suspect on my database in Sybase?