27 April 2011

Find databases where SQL Server log file is too large

Have you ever faced a scenario where your log files weren’t getting properly backed up and truncated so they ate up all the free space on SQL Server? Yeah, most of us have. MSSQLTips has SQL code to Find databases where SQL Server log file is too large. This lets you prevent the locked up server embarrassment.