也是这个问题的错误,即日志log文件自增长过长,log 自增长配置 10%扩容 2014GMax,但是如果log过大50G,10%增长就是5G,这样数据库分配时间超长,在此时间期内请求数据,数据是无响应的,即超时过期。
USE[master]
GO
ALTER DATABASE THTreasureDB SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE THTreasureDB SET RECOVERY SIMPLE
GO
USE THTreasureDB
GO
DBCC SHRINKFILE (N’THTreasureDB_log’ , 2, TRUNCATEONLY)
GO
USE[master]
GO
ALTER DATABASE THTreasureDB SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE THTreasureDB SET RECOVERY FULL
GO