SQL Server Training | Tutorials | How to's

Following script helps us to get

1. Current total Log File size occupied by every database
2. How much space is free inside a log file

-- ***********************************************************************************/
-- Description  :    Script to check space used by all log files  
--                        space used for all log files
-- Compatibility  :     7.0+
-- This Script should be executed in master
-- ***********************************************************************************/
use master
go
Dbcc sqlperf(logspace) 
go

OUTPUT