Results 1 to 2 of 2

Thread: transaction logs full

  1. #1
    Harish Guest

    transaction logs full


    when i try to delete the records it gives the errror
    suggest me how to deal with this problem
    =====
    Msg 1105, Level 17, State 2
    Can't allocate space for object 'Syslogs' in database
    'armaster' 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.

  2. #2
    Davy Guest

    transaction logs full (reply)

    expand the size of the LOG device for the database, or create a NEW LOG device for the database and expand the database log into this device. Once you have done this, dump the transaction log.


    ------------
    Harish at 8/31/01 9:50:50 AM


    when i try to delete the records it gives the errror
    suggest me how to deal with this problem
    =====
    Msg 1105, Level 17, State 2
    Can't allocate space for object 'Syslogs' in database
    'armaster' 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •