SQL Database Size Report for multiple sql srvers, instances & databases
Posted on 2012-04-02
We have multiple sql server boxes used as a back end for a variety of applications such as sharepoint, hyperion, navigon etc.
The question is how best we can collate (a report) which contains list of databases (instace & server names) & the size on disk.
This is just to track database growth for all sql servers from one interface/report.
Have tried out SSMS > Mangement > Management Data warehouse > disk usage reports.
Asking for same as such but for all sql databases, instances & servers in the data centre & report in one instance,database only.
Also, any altenative is most welcome.
In SQL space, we have 2005, 2008, 2008 R2 version.