USE [master]

ALTER DATABASE [ITVS_Archive] SET RECOVERY SIMPLE WITH NO_WAIT

ALTER DATABASE [ITVS_COPN] SET RECOVERY SIMPLE WITH NO_WAIT

ALTER DATABASE [ITVS_CORE] SET RECOVERY SIMPLE WITH NO_WAIT

ALTER DATABASE [ITVS_TDEC] SET RECOVERY SIMPLE WITH NO_WAIT

ALTER DATABASE [ITVS_TTRS] SET RECOVERY SIMPLE WITH NO_WAIT

ALTER DATABASE [ITVS_TEMP] SET RECOVERY SIMPLE WITH NO_WAIT

USE [ITVS_ARCHIVE]

DBCC SHRINKFILE (N'ITVS_ARCHIVE_log' , 0, TRUNCATEONLY)

USE [ITVS_COPN]

DBCC SHRINKFILE (N'ITVS_COPN_log' , 0, TRUNCATEONLY)

USE [ITVS_CORE]

DBCC SHRINKFILE (N'ITVS_CORE_log' , 0, TRUNCATEONLY)

USE [ITVS_TDEC]

DBCC SHRINKFILE (N'ITVS_TDEC_log' , 0, TRUNCATEONLY)

USE [ITVS_TTRS]

DBCC SHRINKFILE (N'ITVS_TTRS_log' , 0, TRUNCATEONLY)

USE [ITVS_TEMP]

DBCC SHRINKFILE (N'ITVS_TEMP_log' , 0, TRUNCATEONLY)

USE [master]

ALTER DATABASE [ITVS_Archive] SET RECOVERY FULL WITH NO_WAIT

ALTER DATABASE [ITVS_COPN] SET RECOVERY FULL WITH NO_WAIT

ALTER DATABASE [ITVS_CORE] SET RECOVERY FULL WITH NO_WAIT

ALTER DATABASE [ITVS_TDEC] SET RECOVERY FULL WITH NO_WAIT

ALTER DATABASE [ITVS_TTRS] SET RECOVERY FULL WITH NO_WAIT

ALTER DATABASE [ITVS_TEMP] SET RECOVERY FULL WITH NO_WAIT