清空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