SQL数据库收缩命令

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' , 200, TRUNCATEONLY)--设置压缩后的日志大小为200M,可以自行指定
GO
USE [master]
GO
ALTER DATABASE cnstock SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE cnstock SET RECOVERY FULL--还原为完全模式
GO