Question

What is the difference between MDF and LDF files in Microsoft SQL Server? give examples.

Answer 1

MDF :

1) mdf stands for "master database file".

2) these file conntains all the startup information for the database to run and track all the databases.

3) it also points to other files in database.

4) these file is also a key file in storing information that is very important in supervision of data content on server.

LDF :

1) ldf is the file extension ofr server transaction log for the main data file.

2) it saves the database info. to keep a record of all the action and change made on the information.

3) it also features the computer terminal where the changes were made.

differnece:

1) MDF is primary data file for microsoft sql. the LDF, on the other hand, is a supporting file .

2) MDF contain all the info. in databases which are necessary and vital . LDF contain all the action related to transaction and changes made in MDF.

3) LDF is concerned with three operation but MDF is not.

4) MDF file can maintain or a change in file size depending on the actual changes made to a file. while, LDF file size can take up a lot of space due to the numerous changes.