1、设置作业
USE master GO ALTER DATABASE DataAnalysisDB_Business SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE DataAnalysisDB_Business SET RECOVERY SIMPLE GO USE DataAnalysisDB_Business GO DBCC SHRINKFILE (DataAnalysisDB_Business_log , 1000, TRUNCATEONLY) GO USE master GO ALTER DATABASE DataAnalysisDB_Business SET RECOVERY FULL WITH NO_WAIT GO ALTER DATABASE DataAnalysisDB_Business SET RECOVERY FULL GO