What is LDF? What Opens a LDF? File Format List from WhatIs.com

File Extension

LDF File Format

Microsoft SQL Server log file

LDF is a file extension for a log file used with Microsoft SQL Server. LDF files contain logging information for all transactions completed by the server. LDF files are used to time stamp any transactions to the SQL Server database, allowing the SQL database to be easily recoverable in the case of data loss.

MIME type: application/octet-stream

The LDF file extension is also used for library definition files for Geoworks Glue.


Learn more about .LDF files:

SearchSQLServer.com provides relevant news, learning resources and expert advice. 

Learn more about SQL Server at ITKnowledgeExchange.com.

Troubleshoot LDF files at the Microsoft Support web page.

This was last updated in August 2010
Editorial Director Margaret Rouse

Ask a Question. Find an Answer.Powered by ITKnowledgeExchange.com

Ask An IT Question

Get answers from your peers on your most technical challenges

Ask Question
  • Truncate SQL Server log file

  • SQL database is crashed

    Follow the steps mentioned below: * Take a tail log backup of your database after your full backup * Restore your Full backup available with you using WITH NORECOVERY option. * Restore Differentia...

  • How to repair backup of .mdf file database?

    HiYou have no need to uninstall/reinstall  SQL Server. You will easily get back your MSDB database from the corrupted instance by the using of a third party utility.Backup of SQL database MDF ...

Tech TalkComment

What made you want to look up LDF Microsoft SQL Server log file? Please tell us where you read or heard it (including the quote, if possible).



    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.