sql restore mode

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