Damn, think of the VLFs. How about you attack the cause of the 90gb log file? More frequent log backups or break the activity into multiple transactions. Any sort of auto shrinking makes me feel a little uneasy.
Well as I said in the article, this really is for the rare case...not for regular use, for these reasons. Every so often, you have a special circumstance where a log shrink is warranted.
Damn, think of the VLFs. How about you attack the cause of the 90gb log file? More frequent log backups or break the activity into multiple transactions. Any sort of auto shrinking makes me feel a little uneasy.
MidnightDBA [OP] 1 points · Mar 2016
Well as I said in the article, this really is for the rare case...not for regular use, for these reasons. Every so often, you have a special circumstance where a log shrink is warranted.