SQL 2008 R2 收缩日志，不用修改简单模式

BACKUP LOG jmd8 TO DISK = N'C:jmd8_20140429014500.trn' WITH NOREWIND, NOUNLOAD

USE [JMD8]
GO
DBCC SHRINKFILE (N'ChaoRan_Log' , 1)
GO