Each month we make an end of month snapshot of our production databse. 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?
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.
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