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