首页 > 代码库 > sql restore mode

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 

 

sql restore mode