SQL Server – Check Log File Size and Fill Percentage DBCC SQLPERF('LogFile') Reference: http://msdn.microsoft.com/en-us/library/ms189768.aspx