What is LDF File Extension?

Overview

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.

Category

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

MIME Type

Application/octet-stream

Location

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.