USE xxt
GO
ALTER DATABASE xxt SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE xxt SET RECOVERY SIMPLE --简单模式
GO
USE xxt
GO
DBCC SHRINKFILE (N'xxt_Log' , 11, TRUNCATEONLY)
GO
USE xxt
GO
ALTER DATABASE xxt SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE xxt SET RECOVERY FULL --还原为完全模式
GO
SQL2008压缩清除日志方法
最新推荐文章于 2024-08-09 19:33:38 发布