<div>
<div class="content wysiwyg-content">
I have about 20 sql server instances.<br />
<br />
<br />
&nbsp;a query that will run on management studio that will just list the database files and their size (ldf and mdf)<br />
hopefully this query would work on 2008,2012, and 2014
</div>
</div>


I have about 20 sql server instances.


 a query that will run on management studio that will just list the database files and their size (ldf and mdf)
hopefully this query would work on 2008,2012, and 2014

query the size of mdf and ldf files

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.