What is LDF File Extension?


LDF stands for Log Database File which is a log or database file, supported by MS SQL server. It efficiently holds all the transaction event/logs which are executed on the database. The prime aim of using LDF files is to save data from loss in SQL Server. Users can easily identify the file extension as .ldf. A log file saves with the same file name as its associated MDF file.


it is associated with Log database file.

Supportive Apps

The only app supported by LDF is MS SQL Server.

File Signature

Hex: 01 0F 00 00 08 , ASCII




The location is depended on the version of SQL Server.

SQL Server 2012

C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\

SQL Server 2014

C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\

SQL Server 2016

C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\

How to view LDF File Extension

An LDF file can be accessed with the help of SQL Command Line app. There are many free tools that can help to open LDF files.