| SQL Server database is mainly associated with two types of files:
(1)*.mdf
(2)*.ldf
Both of these files contains data but there is some condition is that if *.mdf files are actual physical database files where our data is stored finally. *.ldf (LOG) files are actually data which is recorded from the last time data was committed in the database.
 | | |