Post reply

How to get the actual log file space used

  • October 27, 2004 at 2:44 am

    #86793

    Azzam I hope u didn't got my problem.

    sysfiles never gives actual transaction log file used, it only gives allocated log file size and maximum log file size.

     

  • October 27, 2004 at 2:32 pm

    #528221

    I recently spent a considerable amount of time trying to do just that.  What I discovered is that SQL considers multiple transaction log files to be a single container.  You can get space information about all the log files together, but not individually. Perhaps someone has figured out a way, but I was unable.

    Steve

  • October 28, 2004 at 1:15 am

    #528247

    How about select * from sysfiles, this will show the database physical files and their sizes. You may want to insert the result into a table and format output as you wish.

  • October 28, 2004 at 6:52 am

    #528289

    select [name],cast(FILEPROPERTY(name,'SpaceUsed') as int)*8 as SpaceUsedKB

    from sysfiles

     

  • October 28, 2004 at 1:56 pm

    #528340

    Try: dbcc sqlperf(logspace)

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • October 29, 2004 at 4:24 am

    #528376

    Mr Pavan Mr.Rudy komacsar

    may correct

    DBCC SQLPERF(LOGSPACE)

Viewing 6 posts - 1 through 5 (of 5 total)

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