ALTER DATABASE DatabaseName SET RECOVERY SIMPLE

GO

USE MASTER

GO

USE DatabaseName

GO

DBCC SHRINKFILE (DatabaseName_log, 1)

GO

ALTER DATABASE DatabaseName SET RECOVERY FULL

GO

%d bloggers like this: