Sql Server 2008 How To View The Database Log File Size In Sql Server

  USE <database name>;

  SELECT name,
  SIZE, -- in KB
  MAX_SIZE, -- in KB
  GROWTH,
  IS_PERCENT_GROWTH
  FROM SYS.DATABASE_FILES
  WHERE TYPE_DESC= 'LOG'