.LDF File Extension

SQL Server Transaction Log File

Developer: Microsoft

Learn about .LDF files and view a list of programs that open them.

What is a .ldf file?

Learn about .LDF files and view a list of programs that open them.

Properties

Related Formats
3d3d23dm3ds3ds-to-dae3ds-to-dwg3ds-to-fbx3ds-to-glb3ds-to-gltf3ds-to-obj3ds-to-pdf3ds-to-ply3ds-to-stl3ds-to-usdz3mf3mf-to-3ds3mf-to-dae3mf-to-glb3mf-to-html3mf-to-obj

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.

Technical Details

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.

How to open .ldf files

To open a .ldf file, you need compatible software that supports this file format.

Programs that open .ldf files:

Windows
Open over 400 file formats with File Viewer Plus.Free Download
Microsoft SQL Server 2019
Microsoft Notepad
gVim

Quick Facts

File Extension
.ldf
Developer
Microsoft
File Type
SQL Server Transaction Log File
Last Updated
2025-11-02T02:43:26.523Z

Related File Types

LDF File - SQL Server Transaction Log File | What is .ldf?