1.先查询日志名称
select * from sysfiles
2.USE[DataName]
GO
ALTER DATABASE [DataName] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [DataName] SET RECOVERY SIMPLE --简单模式
GO
USE [DataName]
GO
DBCC SHRINKFILE (N'日志名称' , 11, TRUNCATEONLY)
GO
USE[DataName]
GO
ALTER DATABASE [DataName] SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE [DataName] SET RECOVERY FULL --还原为完全模式
GO