清空sql Server 日志文件脚本

1	BACKUP LOG HRM83Demo WITH TRUNCATE_ONLY DBCC SHRINKDATABASE(HRM83Demo)

Sql server 2008

 

USE BJFOURSEASONS 

GO

ALTER DATABASE bjfourseasons

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

GO

DBCC SHRINKFILE (HANHRM_log, 1);

GO

ALTER DATABASE bjfourseasons

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

GO