ALTER DATABASE '数据库名' SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE '数据库名' SET RECOVERY SIMPLE
GO
USE '数据库名'
GO
DBCC SHRINKFILE (N'数据库名_log' , 11, TRUNCATEONLY)
GO
ALTER DATABASE '数据库名' SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE '数据库名' SET RECOVERY SIMPLE
GO
USE '数据库名'
GO
DBCC SHRINKFILE (N'数据库名_log' , 11, TRUNCATEONLY)
GO