收缩数据库命令

一、收缩数据库日志命令：
USE [master]
GO
ALTER DATABASE CoCo_sum SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE CoCo_sum SET RECOVERY SIMPLE
GO
USE CoCo_sum
GO
DBCC SHRINKFILE (N'CoCo_sum_log' , 11, TRUNCATEONLY) 
GO
USE [master]
GO
ALTER DATABASE CoCo_sum SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE CoCo_sum SET RECOVERY FULL
GO

ALTER DATABASE CoCo_Mid SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE CoCo_Mid SET RECOVERY SIMPLE
GO
USE CoCo_Mid
GO
DBCC SHRINKFILE (N'CoCo_Mid_log' , 11, TRUNCATEONLY) 
GO
USE [master]
GO
ALTER DATABASE CoCo_Mid SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE CoCo_Mid SET RECOVERY FULL
GO

二、收缩数据库命令

ALTER DATABASE [CoCo_Mid] SET RECOVERY SIMPLE
DBCC SHRINKDATABASE([CoCo_Mid], 0)
ALTER DATABASE [CoCo_Mid] SET RECOVERY FULL