• ldf is Log data file, i.e. the Transaction Log of a database in SQL Server.
    It logs the transactions and data modifications in the database.
    Right click on the database go to Properties and then chose Files and you'll see there the log file (File type = LOG)
    For details, read this stairway - http://www.sqlservercentral.com/stairway/73776/

    Igor Micev,My blog: www.igormicev.com