1. 收缩数据日志

1.1. 业务数据库

收缩代码如下，需要替换如图所示的内容

use ebs2java  
go 
alter database ebs2java  set recovery simple with no_wait 
go 
alter database ebs2java set recovery simple 
go 
dbcc shrinkfile(N'ebs2java_Log' , 0,truncateonly)
go 
alter database ebs2java set recovery full with no_wait
go 
alter database ebs2java set recovery full 
go 

use ebs_kernel  
go 
alter database ebs_kernel  set recovery simple with no_wait 
go 
alter database ebs_kernel set recovery simple 
go 
dbcc shrinkfile(N'ebs_kernel_Log' , 0,truncateonly)
go 
alter database ebs_kernel set recovery full with no_wait
go 
alter database ebs_kernel set recovery full 
go

1.2. 系统数据库

系统数据需要重新启动SQL server 服务或者重启服务器。