Logfile Space Usage on Server

If you want to see how much log file space is free for each database on the server, use the following

DBCC sqlperf(logspace)

Enable xp_cmdshell

sp_configure 'show advanced options',1
reconfigure
sp_configure 'xp_cmdshell',1
reconfigure