What happens if the Log file properties Automatically grow box is unchecked and the log file runs out of space?
Posted on 2007-11-19
We just recently found that a database which only needs a simple recovery model had been using a full recovery model and we shrank the log file from 6Gig to 11MB. Very good news, and useful to know. A couple of other questions - though - so I don't become overconfident.
1) what information does the log file contain for a simple recovery model that is used for a database that is backed up every night? A process each day "refreshes" the records in the database - deletes all today and imports and adds all of the next day. I would assume that this daily activity adds info to the log file - doesn't it?
2) we used the DBCC Shrinkfile command to shrink the size of the log file to 10MB. That was not scientific, just a guess - and then we unchecked the box that says "Automatically Grow File" - was that wise or not? What is the potential impact of having that box unchecked? Could that cause our daily "refresh" to fail? Would it just stop importing rows and we'd never know the difference?