What is the difference between MDF and LDF file?

What is an LDF file?

A file with . ldf extension is a log file maintained by Microsoft SQL Server which is a relational database management system (RDBMS). All the transactions performed on primary database files (MDF)(such as insertion, update, deletion) are recorded in the LDF file. LDF files are critical components of any database.

What is MDF file used for?

mdf extension is a Master Database File used by Microsoft SQL Server to store user data. It is of prime importance as all the data is stored in this file. The MDF file stores users data in relational databases in the form columns, rows, fields, indexes, views, and tables.

What is MDF and log file?

MDF is the primary data file for MSSQL. The LDF, on the other hand, is a supporting file and is characterized as a server transaction log file. 2. MDF contains all the vital and necessary information in databases while the LDF contains all the actions which include transactions and changes made in the MDF file.

What does LDF stand for SQL?

LDF stands for "Log Database File". The . LDF stores changes related to inserts, deletion, updates, addition, etc. Transaction logs kept in the server help in identifying activities related to unauthorized changes as well as where an error is originating.