My Sql Server 2008 ldf file is bigger than my mdf file
I have a Daily Full Backup of my DB as well as my Transaction log, I'm using full recovery model e.g. Database size is 1347 megabytes and my log files is 11379 megabytes But i don't just want to do a shrink on my log file, as a quick fix i want to know what am i missing and why its so large and what can i do to improve this? Any ideas?
Are you backing up the transaction log with truncate? Has the log file been this size for sometime or was there a specific event that caused it to grow to this size? Check the autogrowth on the database to see how often it is growing.