LogFile Size Location

SELECT  name  AS FileName, Filename as Location,    (size * 8) / 1024  AS AllocatedMb
  ,   ( (CAST(FILEPROPERTY(name, 'SpaceUsed' ) AS int) * 8 ) / 1024)  AS SpaceUsedMb
  from sys.sysaltfiles where fileid=2 or filename like '%log'
 
  go
  exec xp_fixeddrives
  go