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

　　

posted @ 2023-05-03 08:47  Ender.Lu  阅读(10)  评论(0)  编辑  收藏  举报