Summarized SQL DB Log file(s), Virtual Log File(s) & Size analysis
Analyze SQL DB Log file(s), Virtual Log files & Size information for all online SQL Databases
Compatible & Tested SQL Versions: 2005, 2008, 2008 R2, 2012, 2014 & 2016
Sample result of the attached script would look like below
1. Open SQL Server Management Studio (SSMS) and connect to SQL Server.
2. Click on “New Query”, copy the complete code and, paste it and run (Complete code).
Base information is gathered from Below mentioned DBCC commands in all SQL Server versions (2005 - 2016).
DBCC LOGINFO is gathered every individual database on SQL Instance