What are the LDF and MDF files in SQL Server ?

Total Post:87

Points:615
 607  View(s)
Ratings:
Rate this:

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

  1. Post:286

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

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.