List database file locations

Below query will list the database file locations on a sql server instance.

USE master

GO

SELECT  name AS [Logical Name],  physical_name AS [DB File Path],  type_desc AS [File Type],  state_desc AS [State]

FROM  sys.master_files

GO