USE [master]
GO
ALTER DATABASE DNName
SET RECOVERY SIMPLE
WITH NO_WAIT
GO
ALTER DATABASE DNName
SET RECOVERY
SIMPLE
GO
USE DNName
GO
DBCC SHRINKFILE
(N'LogFileName' , 0,TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE DNName
SET RECOVERY
FULL WITH NO_WAIT
GO
ALTER DATABASE DNName
SET RECOVERY
FULL
GO
GO
ALTER DATABASE DNName
SET RECOVERY SIMPLE
WITH NO_WAIT
GO
ALTER DATABASE DNName
SET RECOVERY
SIMPLE
GO
USE DNName
GO
DBCC SHRINKFILE
(N'LogFileName' , 0,TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE DNName
SET RECOVERY
FULL WITH NO_WAIT
GO
ALTER DATABASE DNName
SET RECOVERY
FULL
GO