【MSSQL2000 & 2005 清理日志文件SQL指令】
backup log 数据库名称 with NO_LOG 
backup log 数据库名称 with TRUNCATE_ONLY 
DBCC SHRINKDATABASE(数据库名称)

如示例：数据库名称为 OTCMS

backup log OTCMS with NO_LOG 
backup log OTCMS with TRUNCATE_ONLY 
DBCC SHRINKDATABASE(OTCMS)

【SSQL2008 清理日志文件SQL指令】
USE [master]
GO
ALTER DATABASE [数据库名] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [数据库名] SET RECOVERY SIMPLE --简单模式
GO
USE [数据库名]
GO
DBCC SHRINKFILE (N'日志名OTCMS_Log' , 11, TRUNCATEONLY)
GO

如示例：数据库名称为 OTCMS，日志文件为 OTCMS_Log

USE [master]
GO
ALTER DATABASE [OTCMS] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [OTCMS] SET RECOVERY SIMPLE --简单模式
GO
USE [OTCMS]
GO
DBCC SHRINKFILE (N'OTCMS_Log' , 11, TRUNCATEONLY)
GO