图片 1

DBCC CHECKDB 碰到Operating system error 112(failed to retrieve text for this error. Reason: 15105) encountered

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

我们一个SQL
Server服务器在执行YourSQLDBa的作业YourSQLDba_FullBackups_And_Maintenance时遇到了错误:

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

 

 

 

<Exec>

Exec YourSQLDba.Maint.ShowHistoryErrors @JobNo = 1227

 

<ctx>yMaint.backups</ctx>

<row>

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

<Sql>

<ctx>yMaint.IntegrityTesting</ctx>

 

backup log [gewem]

<Sql>DBCC checkDb(‘xxxx’) </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).

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

<err>In case of non-completion of this command check SQLServer
Error Log at 2016-11-17 00:00:03.327 for Spid 67</err>

 

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

</row>

 

</Sql>

 

COMMENT:  (None)

<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)

错误日志里面有下面一些错误信息,如下所示:

 

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

 

JOB
RUN: 
(None)

</err>

Date 2016/11/17 0:53:21

 

</Exec>

Log SQL Server (Archive #8 – 2016/11/18
0:00:00)

 

 

 

      关于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.

Source spid67

 

 

 

     The
process cannot access the file because it is being used by another
process.

图片 1

Message

 

 

DBCC CHECKDB (xxxx) executed by xxxxx found 0
errors and repaired 0 errors. Elapsed time: 0 hours 53 minutes 18
seconds. Internal database snapshot has split point LSN =
00623e60:00004a5b:0001 and first LSN = 00623e60:000048f3:0011. This is
an informational message only. No user action is required.