Why the Recovery Model SIMPLE is a really bad idea
A few weeks ago one of my blog readers asked in a comment if it is a good idea to set the Recovery Model of the model database to SIMPLE, and if there are any downsides of that approach. I can’t emphasise it enough, but using the Recovery Model SIMPLE for a OLTP workload (which …
Why the Recovery Model SIMPLE is a really bad idea + read more