1
vote
4answers
323 views

Managing Log File in SQL Server 2008

These are my current settings: Recovery mode: Simple Logfile initial size: 10 mb Logfile autogrowth: None Database auto shrink: Off The logfile autogrowth is set to None because I don't want the ...
3
votes
3answers
395 views

SQL Server Log File Size Management

I have all my databases in full recovery and have the log backups happening every 15 minutes so my log files are usually pretty small. question is if there is a nightly operation that causes lots of ...
1
vote
3answers
2k views

SQL Server 2008 log file grow ultra huge even in simple recovery

We have a database in SQL Server 2008 for which the Recovery model is set to Simple. Periodically, we run a big update on a big table (15 million rows to update). To accomplish this, we run a Stored ...