我的sql数据库只有34M,但是日志文件有1.6G,但是我的硬盘空间不足无法通过备份来收缩日志文件,而且我的SQL

use yourdatabasename
GO
backup log yourdatabasename with TRUNCATE_ONLY
GO
DBCC SHRINKFILE (逻辑文件名, 收缩后的大小)
GO

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus