Shink Database And Prevent Transaction Log Growth

http://stackoverflow.com/questions/480897/how-can-i-manage-sql-server-log-size
http://help.fogcreek.com/8686/how-to-shrink-sql-server-transaction-logs

ALTER DATABASE [databasename] SET RECOVERY SIMPLE
Go
DBCC SHRINKFILE (databasename_log, 1)
Go
ALTER DATABASE [databasename] SET RECOVERY FULL
Go
USE [master]
GO
ALTER DATABASE [databaseName] MODIFY FILE ( NAME = N'databasename_Log', SIZE = 512000KB , FILEGROWTH = 0)
GO