SQL ServerStorage

Transaction log usage and why it can't truncate

Log size and percent used for every database, then the reason each log can't be reused. LOG_BACKUP means log backups aren't running.

Not yet verified. How scripts are tested

1DBCC SQLPERF(LOGSPACE);2 3SELECT name, recovery_model_desc, log_reuse_wait_desc4FROM sys.databases5ORDER BY name;

Paste it into your query tool.

Open in denrepo

More SQL Server scripts: Storage

• Data and log file size and free spaceSize, free space, growth setting and max size for each file in the current database. Run it in the database you're checking.