use yourdatabasename
GO
backup log yourdatabasename with TRUNCATE_ONLY
GO
DBCC SHRINKFILE (逻辑文件名, 收缩后的大小)
GO
我的sql数据库只有34M,但是日志文件有1.6G,但是我的硬盘空间不足无法通过备份来收缩日志文件,而且我的SQL
comments powered by Disqus
use yourdatabasename
GO
backup log yourdatabasename with TRUNCATE_ONLY
GO
DBCC SHRINKFILE (逻辑文件名, 收缩后的大小)
GO