1 USE [master] 2 GO 3  4 ALTER DATABASE 数据库名称 SET RECOVERY SIMPLE WITH NO_WAIT 5 GO 6  7 ALTER DATABASE 数据库名称 SET RECOVERY SIMPLE 8 GO 9 10 USE 数据库名称11 GO12 13 declare @dbName nvarchar(100)14 15 set @dbName = (SLEECT name FROM sys.database_files WHERE type=1)16 GO17 18 DBCC SHRINKFILE(@dbName,1,TRUNCATEONLY)19 GO20 21 USE [master]22 GO23 24 ALTER DATABASE 数据库名称 SET RECOVERY FULL WITH NO_WAIT25 GO26 27 ALTER DATABASE 数据库名称 SET RECOVERY FULL