alter database DBNAME set recovery simple; go DBCC SHRINKFILE ('DBNAME _Log', 2) go alter database DBNAME set recovery full; go