ALTER DATABASE Bravo7R2 SET RECOVERY SIMPLE;
GO
DECLARE @_DBName_Log NVARCHAR(128);
SET @_DBName_Log = (SELECT TOP(1) name FROM sys.database_files WHERE type = 1)
DBCC SHRINKFILE(@_DBName_Log, 1);
GO
ALTER DATABASE Bravo7R2 SET RECOVERY FULL;
GO