If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Sybase > Ase 11.0.33

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-03-03, 07:03
ELizazevedo ELizazevedo is offline
Registered User
 
Join Date: Oct 2002
Posts: 2
Ase 11.0.33

When i startserver , appears this message:

"Space available in the log segment has fallen critically low in database 'Mydatabase'. All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.

Can't allocate space for object 'syslogs' in database 'Mydatabase' because the 'logsegment' segment is full. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.
00:2003/02/03 10:56:16.78 server Unable to write CHECKPOINT record in database 14 because the log is out of space."

However the engine, startup.

I have execute dump tansaction and checkpoint, but the problem presist.
Have you have, some solution?
Reply With Quote
  #2 (permalink)  
Old 02-26-03, 14:06
rion89 rion89 is offline
Registered User
 
Join Date: Jan 2003
Posts: 2
Re: Ase 11.0.33

Are you executing a backup dump procedure to tape? If not, then create one that executes the dump daily. Try the following command:

dump transaction mydatabase with no_log

Then increase the space allocated for the transaction log either through the command line or sql central.


Quote:
Originally posted by ELizazevedo
When i startserver , appears this message:

"Space available in the log segment has fallen critically low in database 'Mydatabase'. All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.

Can't allocate space for object 'syslogs' in database 'Mydatabase' because the 'logsegment' segment is full. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.
00:2003/02/03 10:56:16.78 server Unable to write CHECKPOINT record in database 14 because the log is out of space."

However the engine, startup.

I have execute dump tansaction and checkpoint, but the problem presist.
Have you have, some solution?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On