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
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