• As Jeff indicated in his post, this is a bad idea. Changing from FULL recovery model to SIMPLE recovery model breaks your log chain. Changing back requires a full or differential backup before further log backups can be taken.

    Constanly shrinking the transaction log can result in fragmented log files.

    May I suggest reading the last article I reference below in my signature block regarding Managing Transaction Logs?