View List of database/log files and their sizes

[alistairpaul]

I'm trying to setup a script or utility to automate the retrieval of all databases on a server, and for each database, get all it's data files, log files, and their allocated sizes as well as their data-used-sizes so I can better keep an eye on space usage.

I've looked into SQL-DMO and have found some good stuff, but am lacking on the space-used for log files. Using T-SQL, and sysdatabases/sysfiles/sysaltfiles, I've found the same thing pretty much.

Does anyone know what I'll need to get this information on a 7.0 box?

Thanks!

 

[SQLBill]

Check out the procedure sp_spaceused. It might give you the information you are looking for.

-SQLBill