try this code to get the file paths for each db on a server.

DROP TABLE #DBFiles

CREATE TABLE #DBFiles

(

[DBName] [nvarchar](100),

[Name] [nvarchar](100),

[Filename] [nvarchar](100)

)

ON [PRIMARY]

INSERT INTO

#DBFiles

EXEC sp_MSforeachdb 'Select ''?'' as DatabaseName, [?]..sysfiles.name,

[?]..sysfiles.filename From [?]..sysfiles'

SELECT

*

FROM

#DBFiles