• looking at that you definatly have a couple of DB that are in simple (WRHL for one) and that will cause that statement to potentially fail..

    i think you should really look at your strategy before implementing any changes though - your databases that are in full recovery are having the log truncated- which is pretty pointless.... you would be better just getting rid of those commands and switching to Simple recovery mode.. Its a lot safer

    MVDBA