USE [master]
GO
ALTER DATABASE icco SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE ICCO
SET RECOVERY SIMPLE
GO
USE ICCO
GO
DBCC SHRINKFILE (N‘iCCO_log‘ , 0,TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE ICCO SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE ICCO SET RECOVERY FULL
GO