Решение:

USE fa
GO
ALTER DATABASE fa SET RECOVERY SIMPLE
DBCC SHRINKFILE (rudenCMS_log, 10);
ALTER DATABASE fa SET RECOVERY FULL