--清除日志语句
DECLARE @sql VARCHAR(500),@dbname VARCHAR(40)
SET @dbname='jiekou_pa'
SET @sql='
USE [master]
ALTER DATABASE '+@dbname+' SET RECOVERY SIMPLE WITH NO_WAIT
ALTER DATABASE '+@dbname+' SET RECOVERY SIMPLE /*简单模式*/
USE '+@dbname+'
DBCC SHRINKDATABASE('''+@dbname+''',5)
DBCC SHRINKFILE (N'''+@dbname+''' , 1, TRUNCATEONLY)
USE [master]
ALTER DATABASE '+@dbname+' SET RECOVERY FULL WITH NO_WAIT
ALTER DATABASE '+@dbname+' SET RECOVERY FULL /*还原为完全模式*/
'
SELECT @sql
EXEC (@sql)