Post reply

Showing unallocated space in ldf files

  • June 24, 2011 at 3:50 am

    #142738

    Hi all

    DBCC SHOWFILESTATS

    can be used to show the unallocated space of mdf and ndf (data) files for a specific database.

    Is there a way that the same information can be returned for the ldf (log) files of a specific database?

    I need to see the values for the actual physical files, not the filegroups.

    Thanks in advance.

  • June 24, 2011 at 4:08 am

    #1343574

    SC.SQL.Dev (6/24/2011)

    Hi all

    DBCC SHOWFILESTATS

    can be used to show the unallocated space of mdf and ndf (data) files for a specific database.

    Is there a way that the same information can be returned for the ldf (log) files of a specific database?

    I need to see the values for the actual physical files, not the filegroups.

    Thanks in advance.

    Is there any reason to see this?

    Check the dbcc loginfo in bol. It'll give you a clear picture.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • June 24, 2011 at 4:12 am

    #1343575

    See the status if its shows 0 the log file not in use if its 2 its in use.

    The log file is just a circular it will reuse the inactive portion of the VLF automatically.

    Truncating the log file

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

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

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