What is the purpose of LDF?

Question

A log file or LDF(Log Database File) is a database file of Microsoft SQL Server, which stores all the transaction logs/events, which executes on the database. The main purpose of using log file in SQL Server is to rollback the database in case of data loss. Log file uses the same filename as its associated MDF file.

What is the purpose of MDF and LDF?

MDF stands for Main Database File and contains all the information in a database. LDF records all the transactions and changes to the database. The ldf is critical for disaster recovery.

Is LDF necessary?

The LDF file is the transaction log and is required for all SQL server configurations. Depending on the recovery mode, will determine how it is used.

Is it OK to delete LDF files?

You should not delete any of the database files since it can severely damage your database! If you run out of disk space you might want to split your database in multiple parts. This can be done in the database's properties. So you are able to put each part of the database to a different storage volume.

Expert · Answer