SQL server 数据库日志满了,日志清理脚本.
问题:在数据库插入数据时,数据一直没有变化,插入不进去,查看日志提示:
Autogrow of file ‘FPSS_log’ in database ‘FPSS’ was cancelled by user or timed out after 30173 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
翻译:
数据库’FPSS’中文件’FPSS_log’的自动增长被用户取消或在30173毫秒后超时。 使用ALTER DATABASE为此文件设置较小的FILEGROWTH值或显式设置新文件大小。
日志文件:“FPSS_LOG” 无法再增长,
搜索了几个博客,我的解决方案如下:
方案一
日志清理脚本:
USE master
GO
ALTER DATABASE fpss SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE fpss SET RECOVERY SIMPLE
GO
USE fpss
GO
DBCC SHRINKFILE (N'fpss_log' , 11, TRUNCATEONLY)
GO
USE master
GO
ALTER DATABASE fpss SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE fpss SET RECOVERY FULL
fpss为数据库名字
查询数据库日志,DBCC LOG(FPSS_LOG)
方案二: