refer : https://msdn.microsoft.com/en-us/library/ms189272.aspx
SELECT name, recovery_model_desc FROM sys.databases WHERE name = ‘model‘ ; GO USE master ; ALTER DATABASE model SET RECOVERY SIMPLE;
simple 就不会有 log
原文：http://www.cnblogs.com/keatkeat/p/6158372.html