USE [master]GOALTER DATABASE DBname SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE DBname SET RECOVERY SIMPLEGOUSE DBnameGODBCC SHRINKFILE (N'DBname_log' , 11, TRUNCATEONLY) GOUSE [master]GOALTER DATABASE DBname SET RECOVERY FULL WITH NO_WAITGOALTER DATABASE DBname SET RECOVERY FULLGO