Hi the below query will solve u r problem.it shows mdf file mdf path and ldf in ldf path

with cte_dbmdfinfo(dbname,dbid,type_desc,filename,mdfpath,mdfsize)

as

(select DB_NAME(database_id),database_id,type_desc,name,physical_name,size from sys.master_files where type_desc='rows'),

cte_dbldfinfo(dbname,dbid,type_desc,filename,ldfpath,ldfsize)

as

(select DB_NAME(database_id),database_id,type_desc,name,physical_name,size from sys.master_files where type_desc='log'),

cte_recovery(database_id,recovery_model)

as

(select...