sqlserver收缩日志
use [Db1] ALTER DATABASE [Db1] SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE([Db1_Log], 1) ALTER DATABASE [Db1] SET RECOVERY FULL WITH NO_WAIT go
use [Db1] ALTER DATABASE [Db1] SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE([Db1_Log], 1) ALTER DATABASE [Db1] SET RECOVERY FULL WITH NO_WAIT go