To easily find the location of database files, run the following query against the SQL server.
USE master;
SELECT
name 'Logical Name',
physical_name 'File Location'
FROM sys.master_files;The result will be a list of databases and their corresponding file location.