摘要：
USE xx; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE xxSET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (xx_Log, 1); GO -- Reset the database recovery model. ALTER DATABASE xxSET RECOVERY FULL; GO 阅读全文
摘要：
-----------------收缩数据库的方法---------------------DECLARE @dbname AS sysnameSET @DBNname = N'数据库名称l'--1.清空日志exec('DUMP TRANSACTION ['+@DBNname +'] WITH NO_LOG')--2.截断事务日志：exec('BACKUP (如果不压缩,数据库的文件不会减小LOG ['+@DBNname +'] WITH NO_LOG')--3.收缩数据库文件exec('DBCC SHRI 阅读全文