• Short answer: you can't turn off the log. That's part of how ACID principles are maintained and you have an intact database system, with the log.

    So with that being the case, why shrink it if it grows again to the same size? When you take log backups, the space gets reused, so set those up, get a good stable size, and leave it alone, checking on it periodically (monthly).

    A few articles:

    http://www.sqlservercentral.com/articles/64582/

    http://www.sqlservercentral.com/articles/69476/