Saber la ruta física de una base de datos local de Microsoft SQL Server (LOCALDB)

SELECT 
    db.name AS DatabaseName,
    mf.name AS LogicalName,
    mf.physical_name AS PhysicalFilePath,
    mf.type_desc AS FileType
FROM 
    sys.master_files mf
INNER JOIN 
    sys.databases db ON db.database_id = mf.database_id
WHERE 
    db.name = 'YourDatabaseName';