USE [master]
GO
ALTER DATABASE TreeRate SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE TreeRate SET RECOVERY SIMPLE --简单模式
GO
USE TreeRate
GO
DBCC SHRINKFILE (N'TreeRate_Log' , 11, TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE TreeRate SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE TreeRate SET RECOVERY FULL --还原为完全模式
GO
压缩数据库日志
压缩2008r2数据库日志
最新推荐文章于 2021-02-19 09:35:50 发布