USE [master]
GO
ALTER DATABASE Consumer_Monitoring SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE Consumer_Monitoring SET RECOVERY SIMPLE --简单模式
GO
USE Consumer_Monitoring
GO
DBCC SHRINKFILE (N’Consumer_Monitoring_log’ , 2, TRUNCATEONLY) --设置压缩后的日志大小为2M,可以自行指定
GO
USE [master]
GO
ALTER DATABASE Consumer_Monitoring SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE Consumer_Monitoring SET RECOVERY FULL --还原为完全模式
sqlServe压缩日志文件
最新推荐文章于 2022-07-07 16:41:19 发布