Home : File Types : LDF File

.LDF File Extension

File Type 1SQL Server Transaction Log File

DeveloperMicrosoft
Popularity
4.3 (13 Votes)
CategoryData Files
FormatBinary

What is an LDF file?

An LDF file is a log file created by SQL Server, a relational database management system (RDBMS) developed by Microsoft. It contains a log of recent actions executed by the database and is used to track events so that the database can recover from hardware failures or other unexpected shutdowns.

More Information

LDF files are transaction logs. These logs contain a history of activity for both fully committed and partially committed transactions to the database (the .MDF file). After an unexpected shutdown, SQL Server can use the transaction log to restore the database to the exact state before the failure.

Transaction logs can be truncated once the database creates a checkpoint, which is a stable state of the database and the log file. RDBMS systems can then safely delete all log data up to the point of the checkpoint, reducing the log file size.

NOTE: LDF files can become very large in size. This is due to the fact that no checkpoint has recently been created. However, it also may be due to open transactions that have not yet been fully committed, or other locks on database records.

FREE DOWNLOAD
Open over 300 file formats with File Viewer Plus.
Programs that open LDF files
Updated 3/20/2018

File Type 2Lingoes Dictionary Source File

DeveloperLingoes Project
Popularity
3.5 (2 Votes)
CategoryData Files
FormatText

.LDF File Association 2

Source file used for specifying dictionary information for Lingoes, a dictionary and text translation program; saved in a plain text format and contains dictionary title information as well as terms and their definitions.

More Information

LDF files are compiled into .LD2 files, which can be imported into the Lingoes software. Currently, users cannot compile their own dictionaries, but Lingoes Project plans to release Lingoes Dictionary Creator software, which will allow users to create LD2 files.

Programs that open LDF files
Updated 5/5/2011

About LDF Files

Our goal is to help you understand what a file with a *.ldf suffix is and how to open it.

All file types, file format descriptions, and software programs listed on this page have been individually researched and verified by the FileInfo team. We strive for 100% accuracy and only publish information about file formats that we have tested and validated.

If you would like to suggest any additions or updates to this page, please let us know.