Print file names

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ed Wagner SSC Guru Points: 287026 More actions · Answer 1

spectra (12/11/2016)
what is command to print current ldf and mdf file names used by all respective databases in my SQL Server 2008 R2 DB ?

Databases are on an instance. This will query the files for all databases on the instance:

SELECT name, fileid, filename

FROM master.sys.sysaltfiles

ORDER BY name;

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

spectra SSCarpal Tunnel Points: 4120 More actions · Answer 3

SSCarpal Tunnel

Points: 4120

December 11, 2016 at 8:36 pm

Thank you guys