george25 (11/9/2010)
I have quite a few very large databases and, like Giles above, I need to shrink the log files after large amounts of data are imported into the databases. All the databases use the simple recovery model. Is it such a bad thing to shrink the log file when using the simple recovery model?
It's a bad idea using ANY recovery model. Shrinking the log file will almost certainly mean it just has to grow again, and that just causes internal fragmentation in the log file which slows everything down. So long as you're taking regular backups then the log file should be at the size it needs to be to handle your largest transactions, which is where you want it to be!