Cacher is the code snippet organizer for pro developers

USE CAD91;
GO
ALTER DATABASE CAD91
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE (CAD91_log, 1);
GO
ALTER DATABASE CAD91
SET RECOVERY FULL;
GO