1台数据库服务器的事情日志备份作业偶尔会油不过生四回备份退步的情状,具体的错误音讯为:

前天遇上二个案例,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 3二,那几个错误代码对应的错误消息为:

 

 

本条“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.

网站地图xml地图