Post reply

negative tempdb log space

  • May 7, 2010 at 10:48 am

    #224218

    My tempdb Log file is located in J drive having capacity 134 GB out of 40 GB is free.

    In the properties window, the size of the log file is showing as

    currently allocated space : 0.50 MB

    Available free space : -12.78 MB(-2556%)

    Any one came across such weird scenario? what might be causing this?

    I am running SQL Server 2008.


    Pradeep Singh

  • May 7, 2010 at 10:50 am

    #1164276

    Actual templog.ldf size on disk is 20 MB.


    Pradeep Singh

  • November 9, 2010 at 2:02 am

    #1248074

    ps.,

    I have the same problem. Not only the LDF has a negative value also the MDF.

    How to solve this? Will a Shrink do the job?

    Image of the Tempdb MDF property:

    http://img189.imageshack.us/i/mdftempdb.png/

    Image of the Tempdb LDF property:

    http://img213.imageshack.us/i/ldftempdb.png/

    Thanks in Advance.

    Henry

  • November 9, 2010 at 3:05 am

    #1248099

    DBCC UPDATEUSAGE

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply