Why do we need the LDF files along with MDF files?

sql-server mdf
Oscar Mederos picture Oscar Mederos · May 10, 2011 · Viewed 27.4k times · Source

What would happen if I delete the .ldf file that is in the same folder that my .mdf file?

Answer

Dustin Laine picture Dustin Laine · May 10, 2011

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. However all queries basically get stored here until successfully committed to the database (MDF).

You will not be able to delete it while SQL server service is running. You can detach the database, delete the log file (LDF) and reattach the data file (MDF). However it will just create a new log file. You really should not need to delete it. If it is getting too large you will need to manage it, typically through the backup process.

Related questions

What is an MDF file?

Is this like an “embedded” database of sorts? A file containing a built in database?

Read More
SQL Server: Importing database from .mdf?

I have an .mdf file on my local box. I have SQL Server 2008 Express and SQL Management Studio 2008 Express installed on my local box. How in the world do I import this .mdf file as a new database into my …

Read More
Attach (open) mdf file database with SQL Server Management Studio

Can you help me how can I open *.MDF file of database created with VisualStudio 2010, into SQL Server Management Studio? Tried to attach by myself, but I cannot navigate to that file for (I guess) some security reason.

Read More