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