What are the LDF and MDF files in SQL Server ?

Total Post:24

Points:170
 374  View(s)
Ratings:
Rate this:

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

  1. Post:280

    Points:1994
    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

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!