HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlModerate

Do I really need to keep .LDF files?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
reallyneedkeepfilesldf

Problem

Each month we make an end of month snapshot of our production database. These month end snapshots are strictly for reporting purposes, there are no inserts, updates or deletes ever done on them. Each of these snapshots has an .MDF and .LDF file.

I want to delete the .LDF files and free up some space on the server. Are there any reasons why I need to keep the .LDF files?

Clarification:

Our production database is recreated each night from file extracts off of another system. We only report off of the production database... no updates are ever done.

Nightly Process:

From what I can tell...

Each night the databse tables are truncated

The tables are populated through a series of bulk insert statements

Indexes are rebuilt

Solution

You shouldn't delete the log file. If you are trying to reattach a data file without the log, SQL Server can technically recreate it, but there are a few potential issues, like if there were open transactions when the database was detached. In which case, you'd have total data loss.

Consume the space, and don't delete your log files. You're asking for trouble with that.

See this article on Transaction Logs, in particular the "Log Mismanagement" portion.

Context

StackExchange Database Administrators Q#17300, answer score: 16

Revisions (0)

No revisions yet.