清理压缩SQL
时间:2021-07-01 10:21:17
帮助过:21人阅读
[master]
GO
ALTER DATABASE AFMS
SET RECOVERY SIMPLE
WITH NO_WAIT
GO
ALTER DATABASE AFMS
SET RECOVERY SIMPLE
GO
USE AFMS
GO
DBCC SHRINKFILE (N
‘AFMS_Log‘ ,
11, TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE AFMS
SET RECOVERY
FULL WITH NO_WAIT
GO
ALTER DATABASE AFMS
SET RECOVERY
FULL
GO
清理压缩SQL
标签:only log span pre trunc nbsp div with sim