[sql]USE [database name] ALTER DATABASE [database name] SET RECOVERY SIMPLE DBCC SHRINKFILE([log file name], ) ALTER DATABASE [database name] SET RECOVERY FULL[/sql]