Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By James Stuckert,
This script is great for determining which files are taking up the most space on a SQL Server. It collects the free space on the drive, space used, the data/log file size, capped size of the file, filegroup, and file name.
If there is a specific drive that is having space issues, you can set that variable to pull data for only those data/log files. You also have the option to report on specific databases and even file IDs.
Space Available vs. Available Free Space