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