SQL Server数据库从入门到精通系列之三:压缩ldf文件
压缩ldf文件命令
use 目标库;
backup log [db_name] to disk='nul';
dbcc shrinkfile(2);
实例:
use dw;
backup log dw to disk=
压缩ldf文件命令
use 目标库;
backup log [db_name] to disk='nul';
dbcc shrinkfile(2);
实例:
use dw;
backup log dw to disk=