mssqlserver收缩日志

USE [master]
GO
ALTER DATABASE 数据库名 SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE 数据库名  SET RECOVERY SIMPLE
GO

USE 数据库名
GO

DBCC SHRINKFILE (日志名 , 10) #DBCC SHRINKFILE (N'WP2017test_log' , 10，tr**only)
GO

USE [master]
GO

ALTER DATABASE 数据库名 SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE 数据库名 SET RECOVERY FULL
GO