How can we help you today? How can we help you today?

Excessive free space in log file - incorrect numbers

I've just received the message:

The log file for database sqlbpa is 3310943000000.00MB and has 3175089000000.00MB of free space (95.90%). It is recommended to shrink the file to avoid excess wasted space

As you can probably guess, these numbers are a little bigger than I would have expected. The log file is actually 504 KB (516,096 bytes) and the MDF is 4.87 MB (5,111,808 bytes).
jsayce
0

Comments

2 comments

Sort by
  • Luis Martin
    I suggest to run
    USE yourdabase
    sp_spaceused @updateusage = 'TRUE'

    and try again.

    Just a thought.
    Luis Martin
    0
  • Jason Cook
    Hi jsayce,
    That is rather a crazy value, could you run the following two commands for me please, and either post here, PM or email me ( jason.cook@red-gate.com ) the results? You'll need to replace "<database>" with the name of the database (sqlbpa).
    DBCC SQLPERF&#40;LOGSPACE&#41;;

USE &lt;database&gt;;
DBCC SHOWFILESTATS;

    Thanks,
    Jason
    Jason Cook
    0

Add comment

Please sign in to leave a comment.