Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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)

Free space for all database files

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.

Total article views: 1494 | Views in the last 30 days: 3
 
Related Articles
FORUM

Log Space

Log Space

FORUM

Log Space

Log Space

FORUM

space managment

space managment

FORUM

Free space

Free space

FORUM

Disk Space (Space Available vs. Available Free Space)

Space Available vs. Available Free Space

Tags
 
Contribute