Experts - a preemptive strike here (hopefully)
My SQL Server 2008 R2 log files are not too big yet, but they will be someday... someday sooner than I care to admit. Our "Recovery Model" is "Bulk Logged" (instead of "Simple" or "FULL").
Will his option work on a "Bulk Logged" DB?
Please First Read this post
before you give me your best answer... it was a painful revelation to me (who is a big fan of the truncate) .. shrinks everything so well... but fragments your DB almost as much as possible.
I need a better way... any ideas!!