Monday, 7 September 2015

What is LDF and MDF in SQL Server?

LDF is abbreviated as LogDataFile and
MDF is abbreviated as MasterDataFile

MDF - In this file all database information are stored.All objects created in the
database are stored in master file.

LDF - In this file all transactions are stored.During Data creation and data modification all activity is logged in log database file.These file will grow for each data transactions.These file can be used for rollback purpose during emergency.

No comments:

Post a Comment