Sql Server .ldf file size
Posted on 2013-06-04
Everything I've read seems to indicate that, because my database is in SIMPLE recovery mode, that my .ldf should not grow that much.
We have a database that is around 5GB in size, it is backed up every night (full backup) and we only ever need to revert to the previous nights backup in the event of an emergency.
The majority of data within the database will change constantly during the day, data becomes stale very quickly, and is replaced by fresh data.
Currently the .ldf file is 7GB but with only 1% in use, we have shrunk the database in the past but it has now grown again and I understand that it is not good practice to keep shrinking on a regular basis due to potential disk fragmentation.
Is there any advice on how I can reduce the size of the .ldf file or if that's the kid of size I should expect with so much data changing so often throughout the day?
My main issue is that the server disk is backed up every night and the backup files are too large currently and would like to reduce the .ldf size if possible.