SQL server 2005 system table to find database log file size

• virgo

  Ten Centuries

  Points: 1266

  More actions

  August 11, 2008 at 6:43 pm

  #124662

  Hi All,

  Can any please let me know the system table name in sql server 2005 to find the log file size of a database as i dont have direct access to production database to check teh log file size.

  Thanks in advance.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  August 11, 2008 at 7:11 pm

  #856444

  sys.database_files has the data you are looking for.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• virgo

  Ten Centuries

  Points: 1266

  More actions

  August 11, 2008 at 7:57 pm

  #856451

  Thanks...even i found the - DBCC SQLPERF (LOGSPACE) which gives complete list