Tony Davis (1/30/2012)
If you surf around you'll probably find reference to an alternative, which is BACKUP LOG TO DISK='NUL'.
Wasn't aware of this one, could be handy one day or another, more knowledge is always appreciate!
Tony Davis (1/30/2012)
Jonathan Kehayais covers this well in Chapter 8 of his "Troublshooting SQL Server book[/url]" (the eBook is currently a free download).
Thank you for the book reference, I'll take a look.
Tony Davis (1/30/2012)
Hi Megistal,I'd be interested to learn why you'd like another way to force log truncation, other than temporarily switch the database to SIMPLE? It's true that the techniques you suggest are now deprecated.
Altering the database that way (FULL -> SIMPLE -> FULL) flush the plan cache and this is quite a problem. Therefore if I can find something similar to the switch recovery model (which has proved to be the best option so far, unfortunately) I'll be glad to avoid that plan cache flush.