List of Database Files for an Instance - SQL Server

Overview

The following SQL statement gives a list of all database files on a SQL Server instance for all databases.

Code

select 
     DatabaseName = d.name
    ,FullFileName = f.physical_name
from 
    sys.master_files f
    inner join master.sys.databases d
        on d.database_id = f.database_id
where 1=1
    and d.name not in ('master', 'msdb', 'tempdb')
order by
    d.name
    ,f.physical_name