• The problem that I have is the logfile growing out of control.

    I like the script but I found that the shrink (from the GUI) didn't work unless you shrink file as opposed to database. Also when you shrink file you must shrink the log file.

    I still can not fathom why MS has changed the shrink so that you must be in simple mode to shrink the logfile. I am used to Oracle, NZ, and TD where this problem just doesn't exist.