正文

Sql Server 2008 清理日志文件

IP云
IP云V管理员/8 阅读
08/27
提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

Use LingZhongSelect NAME,size From sys.database_filesALTER DATABASE LingZhong SET RECOVERY SIMPLE WITH NO_WAITALTER DATABASE LingZhong SET RECOVERY SIMPLEUSE LingZhongDBCC SHRINKFILE(N'LingZhong_log',0,TRUNCATEONLY)ALTER DATABASE LingZhong SET RECOVERY FULL WITH NO_WAITALTER DATABASE LingZhong SET RECOVERY FULL

解决方案二：

USE[master]
GO
ALTER DATABASE YinJi SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE YinJi SET RECOVERY SIMPLE --简单模式
GO
USE YinJi
GO
DBCC SHRINKFILE (N'YinJi_log' , 2, TRUNCATEONLY) --设置压缩后的日志大小为2M，可以自行指定
GO
USE[master]
GO
ALTER DATABASE YinJi SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE YinJi SET RECOVERY FULL --还原为完全模式
GO