Navigation

	Home Page
	Index
	All Pages

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

List of Database Files for an Instance - SQL Server

Overview¶

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