Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007
    Posts
    63

    Unanswered: Space available in the log segment has fallen critically low in database 'tempdb'

    Hi, everyone,

    I got the following error when I want to open a view:

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


    when i used the following command line to check the tempdb log,please refer to the result below, seems that I have enough space to open a view.

    1> use tempdb
    2> go
    1> sp_helpsegment logsegment
    2> go
    segment name status
    ------- ---------- ------
    2 logsegment 0
    device size
    ------ -----
    master 4.0MB
    free_pages
    -----------
    1165

    Objects on segment 'logsegment':

    table_name index_name indid partition_name
    ---------- ---------- ------ --------------
    syslogs syslogs 0 syslogs_8

    Objects currently bound to segment 'logsegment':

    table_name index_name indid
    ---------- ---------- ------
    syslogs syslogs 0

    total_size total_pages free_pages used_pages
    reserved_pages
    ----------------- --------------- --------------- ---------------
    ---------------
    4.0MB 2048 1165 25
    0
    (return status = 0)
    1>
    2>

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Create an extra device (e.g. tempdb_extra) and extend the tempdb on the extra device:
    disk init
    name="tempdb_extra",
    physname="<location of file>",
    size="1000M"
    go
    alter database tempdb on tempdb_extra = "1000M"
    go
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Apr 2007
    Posts
    63
    Got it.
    I will do it, thanks a lot:-)

    Winnie

Posting Permissions

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