image image
Aug.
1
image

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-check-VLF-5bf8597f.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

This script will list the actual log size, used log space, number of actual VLFs, number of used VLFs and other related information of all databases in an instance. Besides, the script will proactively list potential log size and the number of potential VLFs.

You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery