USE [master]
GO
ALTER DATABASE cnstock SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE cnstock SET RECOVERY SIMPLE
GO
USE cnstock
GO
DBCC SHRINKFILE (N'cnstock_Log' , 11, TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE cnstock SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE cnstock SET RECOVERY FULL
GO
SQL2008以上收缩数据库日志方法
最新推荐文章于 2024-07-20 21:25:25 发布