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 logfile to grow. My objective is to keep the log file consistently small as I do not need it for recovery purposes.
Are the both settings okay for that?
Also,what happens if I have a big transaction involving numerous inserts and deletes (over 10 mb worth of change). Will the operation not complete because the log file ran out of space?