USE DBCenter

GO

SELECT file_id, name FROM sys.database_files;  查找日志名称

USE DBCenter ;

GO

ALTER DATABASE DBCenter

SET RECOVERY SIMPLE;--设置简单恢复模式

GO

DBCC SHRINKFILE ('B2BCenter_log',0, TRUNCATEONLY)

GO

ALTER DATABASE DBCenter

SET RECOVERY FULL;--恢复为原模式

GO 

                                              清空日志