• One, you really don't want to shrink your database on a regular basis, it will result in both index and file fragmentation will affect performance. regarding the transaction log, may I suggest reading this article:

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