USE [master]
GO
ALTER DATABASE [MCASDB] SET RECOVERY SIMPLE WITH NO_WAIT
ALTER DATABASE [MCASDB] SET RECOVERY SIMPLE --simple mode
GO
USE [MCASDB]
GO
DECLARE @LogFileLogicalName sysname
SELECT @LogFileLogicalName=Name FROM sys.database_files WHERE Type=1
PRINT @LogFileLogicalName
DBCC SHRINKFILE (@LogFileLogicalName, 1);
GO
USE [master]
GO
ALTER DATABASE [MCASDB] SET RECOVERY FULL WITH NO_WAIT
ALTER DATABASE [MCASDB] SET RECOVERY FULL --full restore
GO