sys.sysfiles1
lists the physical files for a database. select * from master.sys.sysfiles1; status fileid name filename ----------- ------ ------------------------------------------------------------------------------------------------------------ 2 1 master C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\master.mdf 66 2 mastlog C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\mastlog.ldf select * from tq84_db.sys.sysfiles1; status fileid name filename ----------- ------ ------------------------------------------------------------------------------------------------------------ 2 1 tq84_db C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\tq84_db.mdf 66 2 tq84_db_log C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\tq84_db_log.ldf