由于'LOG_BACKUP',数据库'DBName'的事务日志已满。 [SQLSTATE 42000](错误9002)。步骤失败了。 [英] The transaction log for database 'DBName' is full due to 'LOG_BACKUP'. [SQLSTATE 42000] (Error 9002). The step failed.
问题描述
我有多个作业在以下错误下失败。
I have multiple job is failing under following error.
由于'LOG_BACKUP',数据库'XDBName'的事务日志已满。 [SQLSTATE 42000](错误9002)。 步骤失败。
The transaction log for database 'XDBName' is full due to 'LOG_BACKUP'. [SQLSTATE 42000] (Error 9002). The step failed.
我检查了我的两个事务日志文件驱动器是否有足够的空间。如果你们建议我纠正选项,我在这里附上图片。 Autogrowth / Maxsize没有此错误。
I checked my both transaction log files drive has enough space. Here I attached picture if you guys suggest me to correct options for Autogrowth/ Maxsize to not having this error.
推荐答案
检查opentran - >
check opentran -->
SELECT [log_reuse_wait_desc]
  FROM [master]。[sys]。[数据库]
  WHERE [name] = N'dname'; - >什么是显示
SELECT [log_reuse_wait_desc]
FROM [master].[sys].[databases]
WHERE [name] = N'dname'; --> what is showing
检查日志中的可用空间..
check free space in log..
use dbanme
go
选择增长,
名称,文件名,
大小* 8.0 * 1024 /(1024 * 1024)为TotalMB,
fileproperty(名称,'SpaceUsed ')* 8.0 * 1024 /(1024 * 1024)为UsedMB,
size * 8.0 * 1024 /(1024 * 1024) -
fileproperty(name,'SpaceUsed')* 8.0 * 1024 /(1024 * 1024)作为FreeMB
来自
sysfiles
其中
(状态& 0x2)<> 0 - 和'%'等文件名
select growth, name,filename, size*8.0*1024/(1024*1024) as TotalMB, fileproperty(name,'SpaceUsed')*8.0*1024/(1024*1024) as UsedMB, size*8.0*1024/(1024*1024) - fileproperty(name,'SpaceUsed')*8.0*1024/(1024*1024) as FreeMB from sysfiles where (status & 0x2) <> 0 --and filename like ' %'
refer
这篇关于由于'LOG_BACKUP',数据库'DBName'的事务日志已满。 [SQLSTATE 42000](错误9002)。步骤失败了。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!