DB Properities Screen does not show Log File Space (total, used and free)

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  November 11, 2010 at 1:43 pm

  #147559

  With SQL Server 2005 SP3 (running on Windows Server 2003), why is it that the Transaction Log Space does not show when you right click the database and select properties. In SQL Server 2000, when you selected the database and then selected View|Taskpad the Transaction Log Space (total, used and free) would show at the very bottom.

  Is there another method to see the total, used and free transaction log space?

  Thanks in advance, Kevin

• JeremyE

  SSCoach

  Points: 16201

  More actions

  November 11, 2010 at 9:17 pm

  #1249803

  Right click the db>Reports>Standard Reports>Disk Usage

  or to see the log info for all databases

  dbcc sqlperf(logspace)

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  November 11, 2010 at 10:07 pm

  #1249830

  I second JeremyE. Thats how you can get the information in SQL Server 2005.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga