Where does SQL Server store the name and location of the .ldf files?

[Dev2001]

Where does SQL Server store the name and location of the .ldf files?

The .mdf file for a database, its name and location is stored in the master database, as I found.

Thanks ahead.

 

[tlbroadbent]

sysdatabases in master contains the operating-system path and name for the database’s primary file.

sysfiles1 in each database contains one row for each file in a database including the name of the physical device and the full path of the file. Terry

;-) The single biggest challenge to learning SQL programming is unlearning procedural programming. -Joe Celko

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm