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 ...
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 ...
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 ...