---
title: "What are the LDF and MDF files in SQL Server ?"  
description: "What are the LDF and MDF files in SQL Server ?"  
author: "Anonymous User"  
published: 2018-08-03  
updated: 2018-08-03  
canonical: https://www.mindstick.com/forum/34653/what-are-the-ldf-and-mdf-files-in-sql-server  
category: "mssql server"  
tags: ["database", "sql server"]  
reading_time: 1 minute  

---

# What are the LDF and MDF files in SQL Server ?

what's utilization of ldf and mdf [files](https://www.mindstick.com/articles/23302/the-importance-and-advantage-of-keeping-your-important-files-on-the-cloud) in [sql server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server)...?

## Replies

### Reply by Anonymous User

**LDF:-** Its full name is Log Database File. It is stored the information of every transaction logs record for the main database file.

**MDF:-** It is also known as Master Database File. It contains all the main information of the database that is part of the server. Overall it is very important for safe and secure supervision of data. In case this file gets damaged, an MDF recovery procedure is conducted to recover it.


---

Original Source: https://www.mindstick.com/forum/34653/what-are-the-ldf-and-mdf-files-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.