What are the LDF and MDF files in SQL Server ?

Posted by  Sanat Shukla
 826  View(s)
Ratings:
Rate this:

what's utilization of ldf and mdf files in sql server...?

  1. Re: What are the LDF and MDF files in SQL Server ?

    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.

Answer