错误日志里面有下面一些错误信息，您创建源和

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

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

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

Exec YourSQLDba.Maint.ShowHistoryErrors @JobNo = 1227

<Exec>

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

<row>

<ctx>yMaint.backups</ctx>

<ctx>yMaint.IntegrityTesting</ctx>

<Sql>

DESCRIPTION: BackupDiskFile::CreateMedia: Backup device 'M:DB_BACKUPLOG_BACKUPxxxx_[2018-07-30_06h03m10_Mon]_logs.TRN' failed to create. Operating system error 32(failed to retrieve text for this error. Reason: 15105).

<Sql>DBCC checkDb('xxxx') </Sql>

backup log [gewem]

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

to disk = 'M:DB_BACKUPLOG_BACKUPxxxx_[2016-11-22_01h11m05_Tue]_logs.TRN'

</row>

with noInit, checksum, name = 'YourSQLDba:16h16: M:DB_BACKUPLOG_BACKUPxxxx_[2016-11-22_01h11m05_Tue]_logs.TRN'

COMMENT:  (None)

</Sql>

错误日志里面有下面一些错误信息，如下所示：

<err>Error 3202, Severity 16, level 2 : Write on "M:DB_BACKUPLOG_BACKUPxxxx_[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.

Date 2016/11/17 0:53:21

</err>

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

</Exec>

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

Source spid67

这个“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.

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

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.

版权声明：本文由美高梅开户送58元官网发布于美高梅网上游戏,转载请注明出处：错误日志里面有下面一些错误信息，您创建源和