Post reply

view the log file size

  • November 17, 2008 at 4:26 am

    #383400

    Is there a quick way to view the log file size in 2005 Management Studio. This used to be very easy in 2000 but cannot find it for the life of me in 2005 ?

    Also is there a system table that reports on the size of the log file, so that I can report against it.

  • November 17, 2008 at 5:00 am

    #899248

    What command you were using for SQL 2000?

    You can use following command in sql 2000 & 2005

    DBCC SQLPERF (LOGSPACE)

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • November 17, 2008 at 5:34 am

    #899262

    Another option would be using sp_helpfile

    [font="Verdana"]Markus Bohse[/font]

  • November 17, 2008 at 5:39 am

    #899269

    If you're looking for a equivalent of the taskpad view in EM, there's a custom report you can add to SSMS.

    See here for the download.

    [font="Verdana"]Markus Bohse[/font]

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

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