摘要:
USE [master]GO-- 收缩数据库DECLARE @dbname nvarchar(255)SET @dbname = '数据库名称'-- 1.截断事务日志EXEC('BACKUP LOG ['+@dbname+'] WITH NO_LOG')-- 2.收缩数据库EXEC('DBCC SHRINKDATABASE(['+@dbname+'], TRUNCATEONLY)')-- 3.设定自动收缩EXEC('EXEC SP_DBOPTION '''+@dbname+' 阅读全文