Operating system error 32(failed to retrieve text for this error. Reason: 15105)

一台数据库服务器的事务日志备份作业偶尔会出现几次备份失败的情况,具体的错误信息为:

昨天遇到一个案例,YourSQLDba做事务日志备份时失败,检查YourSQLDba输出的错误信息如下:

 

 

 

<Exec>

DATE/TIME:    2018/7/30
12:10:52

<ctx>yMaint.backups</ctx>

 

<Sql>

DESCRIPTION:
BackupDiskFile::CreateMedia: Backup device
‘M:\DB_BACKUP\LOG_BACKUP\xxxx_[2018-07-30_澳门新萄京 ,06h03m10_Mon]_logs.TRN’
failed to create. Operating system error 32(failed to retrieve text for
this error. Reason: 15105).

backup log [gewem]

 

to disk =
‘M:\DB_BACKUP\LOG_BACKUP\xxxx_[2016-11-22_01h11m05_Tue]_logs.TRN’

 

with noInit, checksum, name = ‘YourSQLDba:16h16:
M:\DB_BACKUP\LOG_BACKUP\xxxx_[2016-11-22_01h11m05_Tue]_logs.TRN’

COMMENT:  (None)

</Sql>

 

<err>Error 3202, Severity 16, level 2 : Write on
“M:\DB_BACKUP\LOG_BACKUP\xxxx_[2016-11-22_01h11m05_Tue]_logs.TRN”
failed: 112(error not found)

JOB
RUN: 
(None)

Error 3013, Severity 16, level 1 : BACKUP LOG is terminating abnormally.

 

</err>

 

</Exec>

      关于Operating
system error 32,这个错误代码对应的错误信息为:

 

 

这个“failed
:112”信息一出现,意味着肯定是磁盘空间不够,昨天总结的那篇博客DBCC
CHECKDB 遭遇Operating system error 112(failed to retrieve text for this
error. Reason: 15105)
encountered其实遇到的问题也是类似的,Operating
System error 112 meaning There is not enough space on the disk.

发表评论

电子邮件地址不会被公开。 必填项已用*标注