Answers

Question and Answer:

  Home  Sybase

⟩ 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.

 162 views

More Questions for you: